0,000 rows with 20 distinct values is a terrible candidate for indexing; a
million rows with one-hundred-thousand distinct values would probably be a win,
if the values are used in queries. Ceteras Parabus.
HTH,
Greg Williamson
- Original Message
From: Ben Brehmer
To: postgis-users@postgis
EXPLAIN ANALYZE statement (wrap it in a
transaction and roll it back when done if it does any updates etc. that you
don't want to keep) ... this will take longer than the regular evaluation
because of the timing calls but gives useful information about what the planner
is doing.
H
y
column would make sense, with strict not allowing bad geoms. Then I could load
into the non-strict and massge the shapes into a strict column.
But I don't think that's very good from a relational database aspect -- I can't
think of any other data that would behave like t
coordinates and cast them to integers,
something like:
X(point)::integer, Y(point)::integer ... cumbersome but it should trim off
those decimal points.
HTH,
Greg Williamson
From: Bob Pawley
To: PostGIS Users Discussion
Sent: Sunday, May 3, 2009 2:10:03 PM
error were documented. I wasted some time trying to fix the problem when I
could have just ignored it.
Greg Williamson
- Original Message
> From: Steffen Macke
> To: PostGIS Users Discussion
> Sent: Wednesday, May 6, 2009 12:22:50 PM
> Subject: Re: [postgis-users]
of partioning, especially to deal with requirements like "I want to see
any street with "HECH" in its name.
HTH,
Greg Williamson
From: Alessandro Ferrucci
To: postgis-users@postgis.refractions.net
Sent: Friday, June 5, 2009 7:29:54 AM
Subje
Pedro --
Is there an index on customer_id ? And have you analyzed the table after
loading it to update the statistics ?
HTH
Greg Williamson
- Original Message
From: Pedro Doria Meunier
To: PostGIS Users Discussion
Sent: Friday, June 12, 2009 1:54:11 AM
Subject: Re: [postgis
specific postGIS/GEOS
version.
HTH,
Greg Williamson
From: Smith Roman
To: postgis-users@postgis.refractions.net
Sent: Friday, September 4, 2009 2:20:05 AM
Subject: [postgis-users] use of spatial index in nearest neighbour query ?
Hi,
I will like to find out
Mark --
If you cut&paste the first of the errors you get that would be of help
(everything after it will be aborted so you could be getting a lot of messages
after the relevant one).
Also details on postgres version and full version of postGIS might help.
Your suspicion about not finding the /
Fabrice --
I can't speak to Oracle directly, but Informix supports a SERIAL type
(different mechanics under the hood but IIRC the port from Informix to postgres
didn't have any issues with DDL declaring a SERIAL type. I'd go with that,
personally, although BIGINT sequence might be needed if you
What SRID(s) ? Could you give an example, perhaps ?
Greg W.
- Original Message
From: Birgit Laggner
To: PostGIS Users Discussion
Sent: Mon, April 12, 2010 5:43:24 AM
Subject: [postgis-users] st_area and 0.001953125
Dear list,
when I use st_area(), I always get multiples of 0.001953
r place name, or by a bounding
box.
That said, I haven't used the referred function so I may be misleading with the
best of intentions. :-}
HTH,
Greg Williamson
From: ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ
To: PostGIS Users Discussion
Sent: Tue, March 8, 2011 2:
leave recreating indexing
and running analyze on the new table.
> The GIS viewer is missing the radar data sometimes so I'm looking for
> the most effective and fastest way to load and refresh the data.
I am not sure what you mean -- perhaps not seen bec
Placing a password in a script is somewhat less secure than something like:
<http://www.postgresql.org/docs/8.4/static/libpq-pgpass.html>
(depending on which version postgres you are using).
HTH,
Greg Williamson
From: Dheeraj Chand
To: PostGIS
source, and may help.
I hope ...
Greg WIlliamson
From: Christian Guirreri
To: PostGIS Users Discussion ; Christian
Guirreri
Sent: Tuesday, June 28, 2011 3:07 PM
Subject: Re: [postgis-users] Noob request - using ST_SimplifyPreserveTopology()
on Tiger Data
On T
into a toast table to that the row size of the original table
doesn't grow excessively. See, for example,
<http://www.postgresql.org/docs/9.0/interactive/storage-toast.html>
So I suspect what happened is that someone entered some long text values and
postgres created the toast ta
on't have a fixed size. ..."
So maybe you got some large geometries that triggered TOAST processing ?
Greg W.
>
>
>Von: Greg Williamson
>An: Robert Buckley ;
>"postgis-users@postgis.refractions.net"
>; PostGIS Users Discussi
a postGIS database can certainly have
a lot of. The extra time in grabbing the compressed value from the TOAST table
is far outweighed by the improvement in utilization of pages by rows of data.
Greg Williamson
>
>____
>Von: Greg Williams
Perhaps more information on the specific pg_dump / pg_restore commands used,
and some information on the servers would be useful ?
Greg Williamson
- Original Message -
> From: René Fournier
> To: PostGIS Users Discussion
> Cc:
> Sent: Wednesday, November 9, 2011 11:10
Ravi --
Could you run this with "EXPLAIN ANALYZE ..." and post the results; that might
give something of a clue as to what issues the planner is encountering.
Greg W.
- Original Message -
> From: Ravi ada
> To: 'PostGIS Users Discussion'
> Cc:
> Sent: Monday, December 12, 2011 8:25
in
analyze
>> SELECT
ag.id,
>>
>> (geocode(ag.address1||','||ag.city||','||ag.state||','||ag.zip)) As
geo
>> FROM qliq.geo_biz_addr As
ag
>> WHERE ag.rating IS
NULL
>> ORDER BY
zip
>>
complicated queries can be slow if things have to get
reprojected on the fly, if there are lots of tests to be applied to lots of
points it just takes time.
HTH,
Greg Williamson
___
> postgis-users mailing list
> post
Try running the query with EXPLAIN ANALYZE ... seeing sequential scans is often
a tip-off to indexes being needed, although there are times when the planner
decides a sequential scan is faster than doing index-driven reads since those
involve more I/O. Post the results here (and if no response i
You might provide a description of the tables (\d at the psql prompt), and
perhaps the output of an "EXPLAIN ANALYZE" for this command. Any non-standard
config settings might be of relevance as well.
Greg Williamson
- Original Message -
> From: Stefan Keller
> T
ayout may also change which necessitates
some hand crafting for the load.
My $0.02 worth ...
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may conta
t / relevance.
Certainly preprocessing data is the way to go and between postGIS and
OGR you've got a lot of tools -- but this is starting to exceed anything
I can even pretend to now about ...
Best of luck,
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidential
Could you post the results of an EXPLAIN ANALYZE ? At least for the 5 table
version -- the 6 table version may take too long.
Also: postgres config settings and version might help shed some light.
Greg WIlliamson
>
> From: "pcr...@pcreso.com&quo
your requirements that might
suggest a cleared focus on one tool or another.
HTH,
Greg Williamson
>
> From: Pierluigi Santin
>To: postgis-users@postgis.refractions.net
>Sent: Saturday, April 28, 2012 12:02 AM
>Subject: [postgis-users] options to scale
Pierluigi --
>>
>> If you can provide some more information about your requirements that might
>> suggest a cleared focus on one tool or another.
>>
>> HTH,
>>
>> Greg Williamson
>>
>
>
>The ideal scenario is 2 identical servers sitti
don't give specific numbers but we had no issues with a database with millions
of rows of spatial data.
The postgres mailing lists (the general ones as well as this one) are very
helpful and polite. Lots of developers available to answer specific questions.
Not as easy to do that with Oracle, me
Jack --
Try running this prefaced by "EXPLAIN ANALYZE " ... that will let us see what
the planner thinks is going. Might be a missing index or something not being
cast in a way that postgres can use an index.
HTH,
Greg Williamson
>
> Fro
ead older databases and collect all the needed data.
HTH,
Greg Williamson
ps the postgres admin mailing list might be a good place to ask more pointed
questions since it has a lot of DBAs looking at it; this forum probably has
more GIS types who may well rely on a regular DBA to do this sort
iles lives with the config file for postgres itself in the
"main" directory, e.g. /etc/postgresql/9.1/main
HTH,
Greg Williamson
>
> From: Smaran Harihar
>To: PostGIS Users Discussion
>Sent: Tuesday, June 19, 2012 11:49 AM
>Subject: [p
Actually --
- Original Message -
> From: Mike Toews
> To: PostGIS Users Discussion
> Cc:
> Sent: Thursday, June 28, 2012 2:53 PM
> Subject: Re: [postgis-users] Create topologic layers from simple geometries
>
> On 27 June 2012 23:51, celati laurent
> wrote:
>> Hello Mike,
>> I ren
bles, etc.
You might also post the version of postgres (e.g. 9.1.x) as that may be useful
information in seeing what is going on. Also, changes from default postgres
settings and information about RAM might help shed some light.
Greg Williamson
>
> From
35 matches
Mail list logo
