Re: 8rc2 & BLCKSZ

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8rc2 & BLCKSZ
Date: 2004-12-22 21:04:50
Message-ID: 20322.1103749490@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Vivek Khera <khera(at)kcilink(dot)com> 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 path (ie,
> 7.4.0 -> 7.4.2 etc.) Forgetting to do that would be disastrous!

Not really --- the postmaster will refuse to start if the BLCKSZ shown
in pg_control doesn't match what is compiled in. I concur though that
there may be no significant performance gain. For some workloads there
may well be a performance loss from increasing BLCKSZ.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Litao Wu 2004-12-22 21:52:40 Re: Why so much time difference with a same query/plan?
Previous Message Vivek Khera 2004-12-22 20:51:02 Re: 8rc2 & BLCKSZ