me more memory cache (OS
cache and postgresql) become busy. I have small row in often loaded
table, 32 bytes. Table is not clustered, used several indices. And you
recommend load 64Kb when I need only 32b, isn't it?
--
Olleg
---(end of broadcast)---
TI
Tom Lane wrote:
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
ile system
journal from second disk. On second /var and pg tables. Thus first disc
is synced time to time, second not.
--
Olleg Samoylov
---(end of broadcast)---
TIP 6: explain analyze is your friend
BLCKSZ
to 4kb. I get some performance improve, but not big, may be because I
have 4Gb on test server (amd64).
Can anyone test it also? May be better move BLCKSZ from
pg_config_manual.h to pg_config.h?
--
Olleg Samoylov
---(end of broadcast
