Was there a specific use case, or reason that those weren't adequate?
cheers
Ben
On Tue, 25 Feb 2020 at 04:05, Diego Vargas wrote:
> Hi all,
>
> Are there any alternatives for the pgsql2shp / shp2pgsql for dumping /
> loading gis data?
>
>
> Thanks!
>
> Diego
>
>
Lots of alternatives.
1) You can use pg_dump / pg_restore if you are dumping PostGIS data and
restoring to another PostGIS enabled database
2) You can use ogr2ogr which will allow you to transfer data from any data
source to another data source (also supports non-spatial though it's primarily
A single query won’t parallelize, so you’ll usually only heat up one core.
With pg12/ you should get more parallel behaviour and better utilitization of a
box that size for analytical queries.
P
> On Feb 25, 2020, at 9:04 AM, Alexander Gataric wrote:
>
> I've been using PostGIS on AWS with
Hi Alexander,
I'd suggest to check if there are differences in the execution of the query
in RDS or in the other box where the query is executed with higher
performances.
I'm specifically talking about to check the outputs of the EXPLAIN (BUFFER,
ANALYSE) of teh query executed in the two boxes.
I've been using PostGIS on AWS with low CPU utilization. I tried 11.6 and 10.11
and RDS size db.m5.2xlarge (8 vCPU, 32 GB).
Any suggestions? Performance is not what I'd expect from a box with those specs.
Get BlueMail for Android
On Feb 25, 2020, 10:34 AM, at 10:34 AM, Alexander Gataric
What parameter file settings are you using? I got low CPU utilization on 11.6
with postgis 2.4.
Get BlueMail for Android
On Feb 25, 2020, 3:31 AM, at 3:31 AM, Stefan Duling
wrote:
>Sorry there is a major typor in my previous mail with the postgres
>version. Each time i wrote 10.4 it has to
Yes, please, if you draw a sample of your tables can you still see the
big time difference in your queries? We cannot easily test against
your production data because (a) we don't have it and (b) it would
take us a long time to just prepare it. I would love to fix this
because you seem to have
On Tue, Feb 25, 2020 at 01:22:39PM +, paul.m...@lfv.se wrote:
> Hi,
> Where do you mean I can play with the tolerance?
In TopoGeo_addLinestring
https://postgis.net/docs/manual-3.1/TopoGeo_AddLineString.html
> This is what I have done before the ST_createTopoGeo
> SELECT
Hi,
Where do you mean I can play with the tolerance?
This is what I have done before the ST_createTopoGeo
SELECT topology.CreateTopology('topo1', 4326)";
SELECT topology.ST_CreateTopoGeo('topo1', ST_Collect(geom)) from
"countries_first";
Btw, I'm intending to simplify later on in my SQL command
On Tue, Feb 25, 2020 at 12:10:07PM +, paul.m...@lfv.se wrote:
>
> Hi,
> I'm running this command:
> SELECT topology.ST_CreateTopoGeo('topo1',ST_Collect("geom")) from
> "countries_first";
>
> and are getting this message:
> ERROR: Corrupted topology: adjacent edges 71 and -72 bind different
Hi,
I'm running this command:
SELECT topology.ST_CreateTopoGeo('topo1',ST_Collect("geom")) from
"countries_first";
and are getting this message:
ERROR: Corrupted topology: adjacent edges 71 and -72 bind different face (36
and 0) CONTEXT: SQL-sats: "SELECT topology.ST_AddEdgeModFace(atopology,
Hi Stefan,
> I haven’t tested the newly released postgis 3.0.1 since there is no easy
installation so far (as long as I see).
If you can create a minimal reproducible example [
https://en.wikipedia.org/wiki/Minimal_working_example ]
then the core developers can easily replicate, debug and fix
Sorry there is a major typor in my previous mail with the postgres version.
Each time i wrote 10.4 it has to be 10.12. Corrected version:
Hello everyone,
I just want to report the outcomes of my latest performance research.
Postgres 12.1 and Postgres 12.2 are both restrictively slow in
Hello everyone,
I just want to report the outcomes of my latest performance research.
Postgres 12.1 and Postgres 12.2 are both restrictively slow in performing our
geometry processing queries - no matter what postgis version (3.0.0, 2.5) I use
and how the raw data came into the db. Setting jit
14 matches
Mail list logo
