I was running out of hard disk space on my root partition. I have,
for now, the geocoder database on a separate partition and hard drive.
I was debugging and capturing the output of every query and command. So
it generated a huge file in the gigabyte range especially when each
query was
On 12/04/11 17:38, Paul Caroline Lewis wrote:
Hi,
Thank you Mark and Richard for your replies. Having looked at this it
seems a Full Vacuum is the answer, however I'm not sure why. Processing
the SQL scripts as originall reported I do get a large table from
TestSet1 and a small table from
Hi Paul,
I'm not expert on Postgres so, maybe I should remain in silence?
Anyway, I know Oracle well and I know that the physical organization of
your data may be highly relevant to performance.
Maybe you could prepare all the data you need on a temporary table and
in the end create another
I'm trying to load a shapefile into a PostGIS database, using shp2pgsql and
psql.
It's failing because a couple of the sql insert statements have date fields
containing '0'.
ERROR: date/time field value out of range: 0
HINT: Perhaps you need a different datestyle setting.
What I need is for
All,
I am wondering if it is possible to return the lat, long coordinates of the
point that the ST_Distance(a.geog, b.geog) function basis its distance
calculation on. Essentially, I'm after ST_ClosestPoint(), but using geography
instead of geometry.
thanks,
Anthony
Anthony Lopez | GIS
All,
Does anyone know if it's possible to specify the number of vertices in
ST_Buffer(geog)? If not, is there a way around this? It seems pretty limiting
to this geography function...
thanks,
Anthony
Anthony Lopez | GIS Analyst
Strategic Energy Analysis Center
National Renewable Energy
