Skip site navigation (1) Skip section navigation (2)

Re: partition question for new server setup

From: Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: partition question for new server setup
Date: 2009-04-28 17:48:40
Message-ID: 8ec76080904281048h19f8e32fv65744e49b625c1f4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks, Scott.

Just to clarify you said:

> postgres.  So, my pg_xlog and all OS and logging stuff goes on the
> RAID-10 and the main store for the db goes on the RAID-10.

Is that meant to be that the pg_xlog and all OS and logging stuff go
on the RAID-1 and the real database (the
/var/lib/postgresql/8.3/main/base directory) goes on the RAID-10
partition?

This is very helpful.  Thanks for your feedback.

Additionally are there any clear choices w/ regard to filesystem
types?  Our choices would be xfs, ext3, or ext4.

Is anyone out there running ext4 on a production system?

-Whit

In response to

Responses

pgsql-performance by date

Next:From: Merlin MoncureDate: 2009-04-28 17:53:45
Subject: pg_lock_status() performance
Previous:From: Scott MarloweDate: 2009-04-28 17:37:13
Subject: Re: partition question for new server setup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group