From: Tom Lane <tgl@sss.pgh.pa.us>
To: Olleg Samoylov <olleg_s@mail.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: BLCKSZ
Date: Mon, 05 Dec 2005 10:02:38 -0500
Message-ID: <29518.1133794958@sss.pgh.pa.us> (raw)
In-Reply-To: <dn1gdd$19kg$1@news.hub.org>
References: <dn1gdd$19kg$1@news.hub.org>
Olleg Samoylov <olleg_s@mail.ru> writes:
> I try to test this. Linux, memory page 4kb, disk page 4kb. I set BLCKSZ
> to 4kb. I get some performance improve, but not big, may be because I
> have 4Gb on test server (amd64).
It's highly unlikely that reducing BLCKSZ is a good idea. There are bad
side-effects on the maximum index entry size, maximum number of tuple
fields, etc. In any case, when you didn't say *what* you tested, it's
impossible to judge the usefulness of the change.
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, olleg_s@mail.ru
Subject: Re: BLCKSZ
In-Reply-To: <29518.1133794958@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