Re: Another try at reducing repeated detoast work for PostGIS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Another try at reducing repeated detoast work for PostGIS
Date
Msg-id 25799.1250616857@sss.pgh.pa.us
Whole thread Raw
In response to Re: Another try at reducing repeated detoast work for PostGIS  (Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk>)
Responses Re: Another try at reducing repeated detoast work for PostGIS  (Andy Colson <andy@squeakycode.net>)
Re: Another try at reducing repeated detoast work for PostGIS  (Mark Cave-Ayland <mark.cave-ayland@siriusit.co.uk>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: "make install" now tries to build the documentation
Next
From: Tom Lane
Date:
Subject: Re: "make install" now tries to build the documentation