!QpRbWTGbWMARUPEeDN:matrix.org

PostGIS

118 Members
Spatial objects for PostgreSQL | http://postgis.net | logs at https://view.matrix.org/alias/%23postgis:matrix.org1 Servers

Load older messages


Timestamp Message
18 Dec 2018
19:23:43@freenode_dbb:matrix.orgdbb.. one does wonder ...
19:24:02@freenode_robe2:matrix.orgrobe2 dbb well they don't have an minor or whatever on theirs so its just st_geometry.so
19:24:31@freenode_robe2:matrix.orgrobe2Well that explains why you need to be hand ties to a version of PostgreSQL if you are using ESRIs sweet types
19:24:35@freenode_dbb:matrix.orgdbb hey robe2 - I have San Francisco cloud'ish source tools hooked up on GEOS today
19:24:46@freenode_dbb:matrix.orgdbbthey like git
19:35:10@freenode_pramsey:matrix.orgpramsey joined the room.
19:40:59@freenode_doskabouter:matrix.orgdoskabouterhi, is there any way I can see if a query is going to use prepared geometry for st_intersects?
19:50:25@freenode_Komzpa:matrix.orgKomzpaguidos: do it via COPY FROM STDIN WITH CSV HEADER;
20:03:02@freenode_guidos:matrix.orgguidosKomzpa: thanks for the suggestion, only issue is that the data is already in an insert statement with $$ and json strings and ST_SetSRID(ST_GeomFromGeoJSON())
20:03:27@freenode_guidos:matrix.orgguidos Komzpa: I totally don't understand if COPY will allow for all of that
20:46:50@freenode_robe2:matrix.orgrobe2guidos is it multiple insert statements or something like one big INSERT .. VALUES (), (), ...
20:47:11@freenode_robe2:matrix.orgrobe2 if it's multiple inserts, I would think you could run a portion of it and commit
21:08:28@freenode_Komzpa:matrix.orgKomzpaguidos: if you have inserts just split them into batches of couple megabytes
21:32:38* @freenode_robe2:matrix.orgrobe2 wonders how guidos ended up with a 10GB insert statement
21:46:16@freenode_sixela:matrix.orgsixelawhich version of postgis does rds use ?
22:23:21@freenode_sixela:matrix.orgsixelaor when is 3.0 expected to be GA ?
22:35:33@freenode_mloskot:matrix.orgmloskot joined the room.
23:14:09@freenode_robe2:matrix.orgrobe2sixela I think RDS has 2.3 - 2.5
23:17:37@freenode_robe2:matrix.orgrobe2but I forget if they only have one PostGIS per PostgreSQL. I think their latest offering is PostgreSQL 10 / 2.4 (maybe 2.4, I have a client running 2.4 / 10)
23:17:53@freenode_robe2:matrix.orgrobe2the PostgreSQL 11 RDS is in experimental not officially released
23:20:26@freenode_robe2:matrix.orgrobe2sixela as far as PostGIS 3.0 we are still debating when we will release - pramsey wants to release in Sept 2019 or earlier to align with PostgreSQL 12
23:21:36@freenode_robe2:matrix.orgrobe2sixela so anyway we are probably 8 months or more away from release, but nothing is set in stone and we are not at feature freeze yet
23:22:24@freenode_robe2:matrix.orgrobe2strk is there any country or continent you would be amenable to a code sprint?
23:23:10@freenode_robe2:matrix.orgrobe2was thinking like a PostGIS / GEOS / pgRouting sprint. pgRouting is planning for their 3.0 in Sept
23:46:44@freenode_sixela:matrix.orgsixelais postgis 3.0 in high demand? seems like only one new feature so far
23:49:40@freenode_robe2:matrix.orgrobe2 sixela no we are still in development - nothing earth shattering yet what's committed so far is listed here - https://git.osgeo.org/gitea/postgis/postgis/src/branch/svn-trunk/NEWS
23:49:43@freenode_sigq:matrix.orgsigqTitle: postgis/postgis: [mirror] PostGIS spatial database extension to PostgreSQL - OSGeo Git Services: Gitea - Git with a cup of tea (at git.osgeo.org)
23:50:41@freenode_sixela:matrix.orgsixela well, if there's a bug, it might be earth shattering ;)
23:51:39@freenode_robe2:matrix.orgrobe2sixela well most of those I would hope would be committed to 2.5
23:52:04@freenode_robe2:matrix.orgrobe2I mean bug fix not the bug itself :)

There are no newer messages yet.


Back to Room List