Re: 7.2 is slow?
Hannu Krosing <hannu@tm.ee>
From: Hannu Krosing <hannu@tm.ee>
To: Tatsuo Ishii <t-ishii@sra.co.jp>
Cc: mathijs@ilse.nl, bpalmer@crimelabs.net, pgsql-hackers@postgresql.org
Date: 2001-12-17T15:37:16Z
Lists: pgsql-hackers
Tatsuo Ishii wrote: > > > Thanks to everyone. Here are the methods I used for testings including > generating graphs (actually very simple). > > (1) Tweak postgresql.conf to allow large concurrent users. I tested up > to 1024 on AIX, but for the comparison I think testing up to 128 > users is enough. Here are example settings: > > max_connections = 128 > shared_buffers = 4096 > deadlock_timeout = 100000 > > You might want to tweak wal_sync_method to get the best > performance. However this should not affect the comparison between > 7.1 and 7.2. > > (2) Run: > > sh bench.sh I have no more time today, but I'll redo the tests with your script tomorrow (after I have found where to stick database name and port :) ---------------- Hannu