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

how to partition disks

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: Pgsql-Performance <pgsql-performance(at)postgresql(dot)org>
Subject: how to partition disks
Date: 2006-06-14 07:52:26
Message-ID: 9e4684ce0606140052m62552d41xa9364b9d4e266c97@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
hi
i'm waiting for new server to arrive.
for the server i will get hp msa1000, with 14 discs (72g, 15000 rpm).
what kind of partitioning you suggest, to get maximum performance?
for system things i will have separate discs, so whole array is only for
postgresql.

data processing is oltp, but with large amounts of write operations.

any hints?

should i go with 3 partitions, or just 1? or 2?

depesz

-- 
http://www.depesz.com/ - nowy, lepszy depesz

Responses

pgsql-performance by date

Next:From: Sven GeislerDate: 2006-06-14 08:26:43
Subject: Re: how to partition disks
Previous:From: AntoineDate: 2006-06-14 06:36:22
Subject: Re: OT - select + must have from - sql standard syntax?

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