Re: BLCKSZ

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Olleg Samoylov <olleg_s@xxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux