BLCKSZ - Mailing list pgsql-performance

From Olleg Samoylov
Subject BLCKSZ
Date
Msg-id dn1gdd$19kg$1@news.hub.org
Whole thread Raw
Responses Re: BLCKSZ
List pgsql-performance
src/include/pg_config_manual.h define BLCKSZ 8196 (8kb).

Somewhere I readed BLCKSZ must be equal to memory page of operational
system. And default BLCKSZ 8kb because first OS where postgres was build
has memory page size 8kb.

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).

Can anyone test it also? May be better move BLCKSZ from
pg_config_manual.h to pg_config.h?

--
Olleg Samoylov

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: Olleg Samoylov
Date:
Subject: Re: two disks - best way to use them?