Re: BLCKSZ

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Olleg Samoylov <olleg_s(at)mail(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: BLCKSZ
Date: 2005-12-05 15:02:38
Message-ID: 29518.1133794958@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Olleg Samoylov <olleg_s(at)mail(dot)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

In response to

  • BLCKSZ at 2005-12-05 13:47:31 from Olleg Samoylov

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-12-05 15:11:41 Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Previous Message Markus Wollny 2005-12-05 14:44:54 Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0