Re: Another try at reducing repeated detoast work for PostGIS

Tom Lane wrote:
> Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk> writes:
>> Thanks for the patch. Fortunately enough I was able to find the dataset 
>> from the original report above, and so I've tested your patch against 
>> PostgreSQL 8.4. Unfortunately in the original test case, it doesn't seem 
>> to give the same performance improvement for me that Paul was seeing :(
> 
> Huh.  As far as I can see this example should traverse the same code
> path.  I was about to ask for the dataset, but I think you might have
> already sent it to me once --- does this look familiar?
> 
> $ tar tvfj geography.tar.bz2
> -rw-r--r-- shade/shade 6444737 2008-06-06 13:33 geography.dbf
> -rw-r--r-- shade/shade 37179008 2008-06-06 13:33 geography.shp
> -rw-r--r-- shade/shade   263140 2008-06-06 13:33 geography.shx
> 
> If so, what do I do with it exactly --- the file extensions convey
> nothing to my mind at the moment ...
> 
>             regards, tom lane
> 

You'll need the postgis stuff I think.

use the shp2pgsql tool, like this:

shp2pgsql -D -S geography geography > geography.sql

-D write dump format (ie COPY)
-S creates simple geom's, if you get an error, remove the -S.

USAGE: shp2pgsql [<options>] <shapefile> [<schema>.]<table>


If you wanna see the data right from the shapefiles, you can use a tool 
like qgis.

.dbf is regular dbase file
.shp is a shapefile (esri shapefile)
.shx is an index


-Andy