Re: new server I/O setup

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: "'Scott Marlowe'" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: new server I/O setup
Date: 2010-01-15 15:49:00
Message-ID: 19362A5CFCD644EBAF1F611BA2AEFEE9@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> -----Mensaje original-----
> De: Scott Marlowe
>
> I think your first choice is right. I use the same basic
> setup with 147G 15k5 SAS seagate drives and the pg_xlog / OS
> partition is almost never close to the same level of
> utilization, according to iostat, as the main 12 disk RAID-10
> array is. We may have to buy a 16 disk array to keep up with
> load, and it would be all main data storage, and our pg_xlog
> main drive pair would be just fine.
>

> > Do you think a single RAID 1 will become a
> bottleneck?
> > Feel free to suggest a better setup I hadn't considered, it
> would be
> > most welcome.
>
> For 12 disks, most likely not. Especially since your load is
> mostly small randomish writes, not a bunch of big
> multi-megabyte records or anything, so the random access
> performance on the 12 disk RAID-10 should be your limiting factor.
>

Good to know this setup has been tryied succesfully.
Thanks for the comments.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tony McC 2010-01-15 16:10:40 Re: New server to improve performance on our large and busy DB - advice? (v2)
Previous Message Robert Haas 2010-01-15 14:41:55 Re: Re: New server to improve performance on our large and busy DB - advice? (v2)