Hi,
I'm unsure how good ST_Transform performs. Did you consider adding a
partial functional index like described in [1] ?
-S.
[1] http://postgis.refractions.net/documentation/manual-1.5/ST_Transform.html
2012/9/18 Shira Bezalel :
>
> I'm trying to determine if the response time we're seeing on
I'm trying to determine if the response time we're seeing on a query is
reasonable or if there's anything we can do to speed it up. Looking for advice
and/or a reality check.
In general, we benefit from dicing our large polygon layers to speed up
intersection queries (a big thanks to Paul Ra
And CPU and hard drive types? I get very different times on different machines
for the same dataset.
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
> boun...@postgis.refractions.net] On Behalf Of Bborie Park
> Sent: Monday, September 17,
Yes, no and maybe. You haven't given sufficient information about your
environment to provide any informed advice.
What is your raster2pgsql command?
Are you piping the output from raster2pgsql directly to psql? Or
loading from a file containing the output?
What OS? PostgreSQL version?
-bbor
Yep. You always need to provide the absolute path for the file. This
is because there is no agnostic way (across different OSes) to determine
the absolute path of a raster file from raster2pgsql.
-bborie
On 09/17/2012 10:55 AM, G. Allegri wrote:
> I simply had to pass the full path to raster2pg
I simply had to pass the full path to raster2pgsql...
giovanni
Sent from Nexus
Il giorno 17/set/2012 18:47, "G. Allegri" ha scritto:
> I've loaded an out of db raster which points to an .adf file (arcinfo
> binary grid).
> Whenever I operate on the column I obatin
>
> "rt_band_load_offline_data
I've loaded an out of db raster which points to an .adf file (arcinfo
binary grid).
Whenever I operate on the column I obatin
"rt_band_load_offline_data: Cannot open offline raster hdr.adf"
Question: is the file path saved or just the file name?
giovanni
__
I'm loading a DEM (float, single band, 27654x17623) through raster2pgsql
and it takes more then hour to complete.
It happens both with tiled loading (256x256) and single block.
Is it normal?
giovanni
___
postgis-users mailing list
postgis-users@postgis.r
Thank you, now perfectly clear.
From: l...@pcorp.us
To: postgis-users@postgis.refractions.net
Date: Mon, 17 Sep 2012 00:35:16 -0400
Subject: Re: [postgis-users] Odd question
The offset is to get you on the right side of the street, not to
compensate for the fuzzyness of census data.
No
