| From: | "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "Bryce Cutt" <pandasuit(at)gmail(dot)com>, "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca> |
| Subject: | Help with Join Performance Testing |
| Date: | 2009-01-21 20:36:14 |
| Message-ID: | 6EEA43D22289484890D119821101B1DF2C18C6@exchange20.mercury.ad.ubc.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
A hash join modification patch is under review for 8.4 that needs
performance testing. We would appreciate help with this testing.
A testing version of the patch is attached in addition to testing
instructions and where to retrieve a sample data set. The basic idea
of the patch is that it reduces disk operations for large multi-batch
hash joins where there is skew in the probe relation. The patch
collects statistics on performance benefits when using the optimization.
--
Ramon Lawrence and Bryce Cutt
| Attachment | Content-Type | Size |
|---|---|---|
| README_Testing.txt | text/plain | 3.5 KB |
| histojoin_testing.patch | application/octet-stream | 34.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2009-01-21 20:36:44 | Re: Pluggable Indexes (was Re: rmgr hooks (v2)) |
| Previous Message | Bruce Momjian | 2009-01-21 20:22:03 | Re: Cancelling idle in transaction state |