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