Re: [PERFORM] 8rc2 & BLCKSZ

2004-12-22 Thread Mario Weilguni
Am Mittwoch, 22. Dezember 2004 22:04 schrieb Tom Lane: > Vivek Khera writes: > > One of the suggestions handed to me a long time ago for speeding up PG > > on FreeBSD was to double the default blocksize in PG. I tried it, but > > found not a significant enough speed up to make it worth the troubl

Re: [PERFORM] 8rc2 & BLCKSZ

2004-12-22 Thread Tom Lane
Vivek Khera writes: > One of the suggestions handed to me a long time ago for speeding up PG > on FreeBSD was to double the default blocksize in PG. I tried it, but > found not a significant enough speed up to make it worth the trouble > to remember to patch every version of Pg during the upgrade

Re: [PERFORM] 8rc2 & BLCKSZ

2004-12-22 Thread Vivek Khera
> "PJ" == Pailloncy Jean-Gerard <[EMAIL PROTECTED]> writes: PJ> Hi, PJ> A small test with 8rc2 and BLCKSZ of 8k and 32k. PJ> It seems there is a 10% increase in the number of transactions by PJ> second. PJ> Does someone plan to carefully test the impact of BLCKSZ ? One of the suggestions hand

[PERFORM] 8rc2 & BLCKSZ

2004-12-22 Thread Pailloncy Jean-Gerard
Hi, A small test with 8rc2 and BLCKSZ of 8k and 32k. It seems there is a 10% increase in the number of transactions by second. Does someone plan to carefully test the impact of BLCKSZ ? Cordialement, Jean-Gérard Pailloncy with 8k: > /test/bin/pgbench -c 10 -t 300 test starting vacuum...end. trans