Re: ext3 block size

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Wilson A(dot) Galafassi Jr(dot)" <juniorlist(at)yahoo(dot)com(dot)br>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ext3 block size
Date: 2003-08-06 20:37:34
Message-ID: Pine.LNX.4.33.0308061436430.16400-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 6 Aug 2003, Wilson A. Galafassi Jr. wrote:

> hello.
> my database size is 5GB. what is the block size recommend?

Well, the biggest block size currently supported by stock linux distros is
4k, so I'd go with that. Postgresql's default block size of 8k is fine
also. Note that linux page/system/file block sizes are NOT related to
Postgresql block sizes.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2003-08-06 20:51:07 Re: partitioning for postgresql
Previous Message Tom Lane 2003-08-06 20:36:31 Re: EXTERNAL storage and substring on long strings