From: Ivan Voras <ivoras@freebsd.org>
To: pgsql-performance@postgresql.org
Subject: Re: Performance block size.
Date: Fri, 27 May 2011 12:54:27 +0200
Message-ID: <irnvt4$es5$1@dough.gmane.org> (raw)
In-Reply-To: <BANLkTimwU7q77JTdU3GH4hCwD5rXopt+SA@mail.gmail.com>
References: <BANLkTimwU7q77JTdU3GH4hCwD5rXopt+SA@mail.gmail.com>
On 27/05/2011 00:34, Tory M Blue wrote:
> Working on some optimization as well as finally getting off my
> backside and moving us to 64bit (32gb+memory).
>
> I was reading and at some point it appears on freeBSD the Postgres
> block size was upped to 16kb, from 8kb. And on my fedora systems I
> believe the default build is 8kb.
This happened some years ago but it was quickly reverted.
There were some apparent gains with the larger block size, especially
since FreeBSD's UFS uses 16 KiB blocks by default (going to 32 KiB
really soon now; note that this has no impact on small files because of
the concept of "block fragments"), but it was concluded that the stock
installation should follow the defaults set by the developers, not
porters. YMMV.
> Trying to gain some performance and wondered if any of this tuning
> even is something I should bother with.
Please do some benchmarks and report results.
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: ivoras@freebsd.org
Subject: Re: Performance block size.
In-Reply-To: <irnvt4$es5$1@dough.gmane.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