pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kenneth Marshall <ktm@rice.edu>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help with 8.4 Performance Testing
Date: Sun, 7 Dec 2008 20:08:56 -0600
Message-ID: <20081208020856.GA24658@it.is.rice.edu> (raw)
In-Reply-To: <200812071138.01215.josh@agliodbs.com>
References: <200812071138.01215.josh@agliodbs.com>

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.

Regards,
Ken

On Sun, Dec 07, 2008 at 11:38:01AM -0800, Josh Berkus wrote:
> 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 detail.
> 
> Particularly, users with unusual hardware architectures (16 or more cores, 
> ARM, Power, SSD, NFS-mounted data) or operating systems (Solaris, OSX, 
> Windows-64) are really helpful.  Testers need to be familiar with building 
> PostgreSQL from source and patching it, as well as basic PostgreSQL Tuning 
> (except for the Wizard Patch) and have some kind of performance test 
> available, ideally something based on your own application use.
> 
> If you are going to use pgbench to test, *please* read Greg Smith's notes 
> first: 
> http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgbench-scaling.htm
> 
> The Wiki (http://wiki.postgresql.org/wiki/CommitFest_2008-11) has a full list 
> of patches, but below are the ones in particular we could use help with.
> 
> You *do* need to read the entire mail threads which I link to below to 
> understand the patches.  Thanks for your help!
> 
> Proposal of PITR performance improvement (Koichi Suzuki):
> http://archives.postgresql.org/message-id/a778a7260811270404g49254640x8ed58b12b7c65d0b@mail.gmail.co...
> http://archives.postgresql.org/message-id/a778a7260810280033n43f70d36x8c437eacf9a5461e@mail.gmail.co...
> 
> Simple postgresql.conf wizard
> http://archives.postgresql.org/message-id/Pine.GSO.4.64.0811012101220.17619@westnet.com
> http://archives.postgresql.org/message-id/Pine.GSO.4.64.0811291403040.12885@westnet.com
> 
> Improve Performance of Multi-Batch Hash Join for Skewed Data Sets
> http://archives.postgresql.org/message-id/6EEA43D22289484890D119821101B1DF2C1683@exchange20.mercury....
> http://archives.postgresql.org/message-id/1924d1180811051606w19aaf30du589e8ea10ea5534d@mail.gmail.co...
> http://archives.postgresql.org/message-id/22901.1227228246@sss.pgh.pa.us
> 
> Window Functions
> http://archives.postgresql.org/message-id/e08cc0400810270912u49a6ec83vc23984c01f368f76@mail.gmail.co...
> http://archives.postgresql.org/message-id/492D1246.5070101@enterprisedb.com
> http://archives.postgresql.org/message-id/839FB90FF49D4120B7107ED0D7B3E5B6@amd64
> 
> parallel restore
> (especially need to test on 16+ cores)
> http://archives.postgresql.org/message-id/490878AC.1@dunslane.net
> 
> B-Tree emulation for GIN
> http://archives.postgresql.org/message-id/491B1888.9020903@sigaev.ru
> http://archives.postgresql.org/message-id/Pine.LNX.4.64.0811191828050.7862@sn.sai.msu.ru
> 
> Also, the following patches currently still have bugs, but when the bugs are 
> fixed I'll be looking for performance testers, so please either watch the 
> wiki or watch this space:
> 
> -- Block-level CRC checks (Alvaro Herrera)
> -- Auto Partitioning Patch (Nikhil Sontakke)
> -- posix_fadvise (Gregory Stark)
> -- Hash Join-Filter Pruning using Bloom Filters
> -- On-disk bitmap indexes
> 
> Please report your results, with the patchname in the subject line, on this 
> mailing list or on -hackers.  Thank you, and your help will get a better 8.4 
> out sooner.
> 
> -- 
> Josh Berkus
> PostgreSQL
> San Francisco
> 
> -- 
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
> 



view thread (56+ messages)  latest in thread

Message-ID: <20081208020856.GA24658@it.is.rice.edu>
Permalink:  ../20081208020856.GA24658@it.is.rice.edu/
Also on:    postgresql.org/message-id/20081208020856.GA24658@it.is.rice.edu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ktm@rice.edu, josh@agliodbs.com
  Subject: Re: Need help with 8.4 Performance Testing
  In-Reply-To: <20081208020856.GA24658@it.is.rice.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox