| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Cc: | Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Avoiding tuple construction/deconstruction during joining |
| Date: | 2005-03-15 17:17:31 |
| Message-ID: | opsnovnhx0th1vuj@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
I have asked him for the data and played with his queries, and obtained
massive speedups with the following queries :
http://boutiquenumerique.com/pf/miroslav/query.sql
http://boutiquenumerique.com/pf/miroslav/query2.sql
http://boutiquenumerique.com/pf/miroslav/materialize.sql
Note that my optimized version of the Big Joins is not much faster that
the materialized view without index (hash joins are damn fast in postgres)
but of course using an index...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-03-15 18:17:19 | Re: type unknown - how important is it? |
| Previous Message | Magnus Hagander | 2005-03-15 16:54:28 | Kerberos code overwrites it's own error message |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2005-03-15 19:53:13 | Re: [PERFORM] Avoiding tuple construction/deconstruction during joining |
| Previous Message | Ruth Ivimey-Cook | 2005-03-15 16:17:55 | Effect of Stripe Size (was Postgres on RAID5) |