parametric block size?

From: Fabien <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: parametric block size?
Date: 2014-07-22 08:22:53
Message-ID: alpine.DEB.2.10.1407221010170.5360@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello devs,

The default blocksize is currently 8k, which is not necessary optimal for
all setup, especially with SSDs where the latency is much lower than HDD.

There is a case for different values with significant impact on
performance (up to a not-to-be-sneezed-at 10% on a pgbench run on SSD, see
http://www.cybertec.at/postgresql-block-sizes-getting-started/), and ISTM
that the ability to align PostgreSQL block size to the underlying FS/HW
block size would be nice.

This is currently possible, but it requires recompiling and maintaining
distinct executables for various block sizes. This is annoying, thus most
admins will not bother.

ISTM that a desirable and reasonably simple to implement feature would be
to be able to set the blocksize at "initdb" time, and "postgres" could use
the value found in the database instead of a compile-time one.

More advanced features, but with much more impact on the code, would be to
be able to change the size at database/table level.

Any thoughts?

--
Fabien.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2014-07-22 09:19:34 Re: Use unique index for longer pathkeys.
Previous Message MauMau 2014-07-22 08:05:22 Re: [bug fix] Suppress "autovacuum: found orphan temp table" message