Postgres Pro
Downloads
Home   >   mailing lists

Re: ext3 block size - Mailing list pgsql-performance

From scott.marlowe
Subject Re: ext3 block size
Date
Msg-id Pine.LNX.4.33.0308061436430.16400-100000@css120.ihs.com
Whole thread Raw
In response to ext3 block size  ("Wilson A. Galafassi Jr." <juniorlist@yahoo.com.br>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Christopher Browne
Date:
Subject: Re: partitioning for postgresql
Next
From: Joe Conway
Date:
Subject: Re: EXTERNAL storage and substring on long strings