Re: [PERFORM] Need help with 8.4 Performance Testing

2008-12-07 Thread Derek Lewis
I'll be glad to test the patches using pgbench on my POWER4 box running AIX 5.3 and an IA64 that runs HP-UX 11.31. Derek On Dec 7, 2008, at 2:38 PM, Josh Berkus <[EMAIL PROTECTED]> wrote: Database performance geeks, We have a number of patches pending for 8.4 designed to improve databas

Re: [PERFORM] file system and raid performance

2008-12-07 Thread M. Edward (Ed) Borasky
Bruce Momjian wrote: > Mark Mielke wrote: >> Greg Smith wrote: >>> On Fri, 15 Aug 2008, Bruce Momjian wrote: 'data=writeback' is the recommended mount method for that file system, though I see that is not mentioned in our official documentation. >>> While writeback has good perform

Re: [PERFORM] Need help with 8.4 Performance Testing

2008-12-07 Thread Scott Marlowe
On Sun, Dec 7, 2008 at 12:38 PM, Josh Berkus <[EMAIL PROTECTED]> wrote: I've got a pair of 8 core opteron 16 drive machines I would like to test it on. If nothing else I'll just take queries from the log to run against an 8.4 install. It'll have to be late at night though... > If you are going

Re: [PERFORM] Need help with 8.4 Performance Testing

2008-12-07 Thread Kenneth Marshall
Josh, Since a number of these performance patches use our hash function, would it make sense to apply the last patch to upgrade the hash function mix() to the two function mix()/final()? Since the additional changes increases the performance of the hash function by another 50% or so. My two cents.

[PERFORM] Need help with 8.4 Performance Testing

2008-12-07 Thread Josh Berkus
Database performance geeks, We have a number of patches pending for 8.4 designed to improve database performance in a variety of circumstances. We need as many users as possible to build test versions of PostgreSQL with these patches, and test how well they perform, and report back in some det