Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3) - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Date
Msg-id E1539E0ED7043848906A8FF995BDA579018FE16D@m0143.s-mxs.net
Whole thread Raw
In response to Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> I don't doubt that there may be a positive effect from increasing the
> block size.  But we haven't seen any analysis of why that
> might be.  If it's just to use the disk system bandwith better, maybe
we should
> combine page writes instead or something.

It is usually the reads that need aid. Writes are fast on modern
disksystems since they are
cached.

I think the main effect is reduced OS overhead for the readahead
prediction logic and
reduced system call overhead.

Andreas


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas ADI SD"
Date:
Subject: Re: Potential to_char localization bug
Next
From: Michael Meskes
Date:
Subject: Re: ecpg_config.h not installed