From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron <rjpeace@earthlink.net>
Cc: Olleg <olleg_s@mail.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: BLCKSZ
Date: Tue, 06 Dec 2005 00:51:13 -0500
Message-ID: <26213.1133848273@sss.pgh.pa.us> (raw)
In-Reply-To: <6.2.5.6.0.20051205183120.01dd6a80@earthlink.net>
References: <dn1gdd$19kg$1@news.hub.org>
<29518.1133794958@sss.pgh.pa.us>
<4394B1D3.7000304@mail.ru>
<6.2.5.6.0.20051205183120.01dd6a80@earthlink.net>
Ron <rjpeace@earthlink.net> writes:
> Where? BLCKSZ as large as 64KB has been shown to improve
> performance.
Not in the Postgres context, because you can't set BLCKSZ higher than
32K without doing extensive surgery on the page item pointer layout.
If anyone's actually gone to that much trouble, they sure didn't
publicize their results ...
>> Postgresql 7.4.8. Server dual Opteron 240, 4Gb RAM.
> _Especially_ with that HW, upgrade to at least 8.0.x ASAP. It's a
> good idea to not be running pg 7.x anymore anyway, but it's
> particularly so if you are running 64b SMP boxes.
I agree with this bit --- 8.1 is a significant improvement on any prior
version for SMP boxes. It's likely that 8.2 will be better yet,
because this is an area we just recently started paying serious
attention to.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, rjpeace@earthlink.net, olleg_s@mail.ru
Subject: Re: BLCKSZ
In-Reply-To: <26213.1133848273@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox