pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Olleg Samoylov <olleg_s@mail.ru>
To: pgsql-performance@postgresql.org
Subject: BLCKSZ
Date: Mon, 05 Dec 2005 16:47:31 +0300
Message-ID: <dn1gdd$19kg$1@news.hub.org> (raw)

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



view thread (9+ messages)  latest in thread

Message-ID: <dn1gdd$19kg$1@news.hub.org>
Permalink:  ../dn1gdd$19kg$1@news.hub.org/
Also on:    postgresql.org/message-id/dn1gdd$19kg$1@news.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: olleg_s@mail.ru
  Subject: Re: BLCKSZ
  In-Reply-To: <dn1gdd$19kg$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox