agora inbox for [email protected]  

help / color / mirror / Atom feed

From: Andy Colson <[email protected]>
To: Tom Lane <[email protected]>
Subject: Re: Another try at reducing repeated detoast work for PostGIS
Date: Tue, 18 Aug 2009 13:07:58 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>

Tom Lane wrote:
> Mark Cave-Ayland <[email protected]> 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

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Another try at reducing repeated detoast work for PostGIS
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox