Re: BLCKSZ - Mailing list pgsql-performance

From Tom Lane
Subject Re: BLCKSZ
Date
Msg-id 29518.1133794958@sss.pgh.pa.us
Whole thread Raw
In response to BLCKSZ  (Olleg Samoylov <olleg_s@mail.ru>)
Responses Re: BLCKSZ
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Markus Wollny"
Date:
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Next
From: Tom Lane
Date:
Subject: Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0