BLCKSZ

From: Olleg Samoylov <olleg_s(at)mail(dot)ru>
To: pgsql-performance(at)postgresql(dot)org
Subject: BLCKSZ
Date: 2005-12-05 13:47:31
Message-ID: dn1gdd$19kg$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Olleg Samoylov 2005-12-05 13:56:55 Re: two disks - best way to use them?
Previous Message Markus Wollny 2005-12-05 10:28:54 Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0