Re: partition question for new server setup

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: Craig James <craig_james(at)emolecules(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: partition question for new server setup
Date: 2009-04-29 14:28:08
Message-ID: 8ec76080904290728ke4150cfsf1d46ff9c6c1dbd4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thanks, Scott.

> I went with ext3 for the OS -- it makes Ops feel a lot better. ext2 for a
> separate xlogs partition, and xfs for the data.
> ext2's drawbacks are not relevant for a small partition with just xlog data,
> but are a problem for the OS.

Can you suggest an appropriate size for the xlogs partition? These
files are controlled by checkpoint_segments, is that correct?

We have checkpoint_segments set to 500 in the current setup, which is
about 8GB. So 10 to 15 GB xlogs partition? Is that reasonable?

-Whit

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message James Nelson 2009-04-29 17:51:34 bad plan and LIMIT
Previous Message Scott Carey 2009-04-29 01:58:51 Re: partition question for new server setup