Here¹s one: Insert performance is limited to about 10-12 MB/s no matter how fast the underlying I/O hardware. Bypassing the WAL (write ahead log) only boosts this to perhaps 20 MB/s. We¹ve found that the biggest time consumer in the profile is the collection of routines that ³convert to datum².
You can perform the test using any dataset, you might consider using the TPC-H benchmark kit with a data generator available at www.tpc.org. Just generate some data, load the schema, then perform some COPY statements, INSERT INTO SELECT FROM and CREATE TABLE AS SELECT. - Luke On 2/14/07 2:00 AM, "Krishna Kumar" <[EMAIL PROTECTED]> wrote: > Hello All, > I'm a performance engineer, quite interested in getting deep into the PGSQL > performance enhancement effort. In that regard, I have the following questions > : > 1. Is there a benchmarking setup, that I can access online? > 2. What benchmarks are we running , for performance numbers? > 3. What are the current issues, related to performance? > 4. Where can I start, with the PGSQL performance effort? > > Thanks a lot, > Krishna >
