| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Another try at reducing repeated detoast work for PostGIS |
| Date: | 2009-08-18 17:34:17 |
| Message-ID: | 25799.1250616857@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Clark | 2009-08-18 17:39:30 | PQgetlength vs. octet_length() |
| Previous Message | Peter Eisentraut | 2009-08-18 17:32:07 | Re: "make install" now tries to build the documentation |