Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group