Re: XFS filessystem for Datawarehousing -2

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Milen Kulev" <makulev(at)gmx(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: XFS filessystem for Datawarehousing -2
Date: 2006-08-02 02:44:20
Message-ID: C0F55F94.2B857%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Milen,

On 8/1/06 3:19 PM, "Milen Kulev" <makulev(at)gmx(dot)net> wrote:

> Sorry, forgot to ask:
> What is the recommended/best PG block size for DWH database? 16k, 32k, 64k
> ?
> What hsould be the relation between XFS/RAID stripe size and PG block size ?

We have found that the page size in PG starts to matter only at very high
disk performance levels around 1000MB/s. Other posters have talked about
maintenance tasks improving in performance, but I haven't seen it.

- Luke

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-08-02 03:15:11 Re: Query/database optimization
Previous Message Luke Lonergan 2006-08-02 02:42:37 Re: XFS filessystem for Datawarehousing