Olleg Samoylov <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
