Re: new server I/O setup - Mailing list pgsql-performance

From Fernando Hevia
Subject Re: new server I/O setup
Date
Msg-id 19362A5CFCD644EBAF1F611BA2AEFEE9@iptel.com.ar
Whole thread Raw
In response to Re: new server I/O setup  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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.


pgsql-performance by date:

Previous
From: "Ing. Marcos L. Ortiz Valmaseda"
Date:
Subject: Re: Re: New server to improve performance on our large and busy DB - advice? (v2)
Next
From: Tony McC
Date:
Subject: Re: New server to improve performance on our large and busy DB - advice? (v2)