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: | Raw Message | Whole Thread | 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 |