Re: Hardware for PostgreSQL

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: Ketema <ketema(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware for PostgreSQL
Date: 2007-11-01 03:53:02
Message-ID: 1193889182.7999.71.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Wed, 2007-10-31 at 22:58 +0100, Tomas Vondra wrote:

> 2) separate the transaction log from the database
>
> It's mostly written, and it's the most valuable data you have. And in
> case you use PITR, this is the only thing that really needs to be
> backed up.

My main DB datastore is in a raid1 array and the xlog is still
maintained in a single OS drive. Is this considered OK?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2007-11-01 06:52:41 Re: Hardware for PostgreSQL
Previous Message Ericson Smith 2007-10-31 23:03:43 Re: Hardware for PostgreSQL