Jim C. Nasby wrote:

On Mon, Jan 31, 2005 at 09:41:32PM +0100, Cosimo wrote:

>2) The goal is to make the db handle 100 tps (something like
>   100 users). What kind of server and storage should I provide?

You might look at Opteron's, which theoretically have a higher data
bandwidth. If you're doing anything data intensive, like a sort in
memory, this could make a difference.

Would Opteron systems need 64-bit postgresql (and os, gcc, ...) build to have that advantage?

>4) Is it correct to suppose that multiple RAID 1 arrays
>   can provide the fastest I/O ?
>   I usually reserve one RAID1 array to db data directory,
>   one RAID1 array to pg_xlog directory and one RAID1 array
>   for os and application needs.

RAID10 will be faster than RAID1.

Sorry Jim, by RAID10 you mean several raid1 arrays mounted on different linux partitions? Or several raid1 arrays that build up a raid0 array? In the latter case, who decides which data goes in which raid1 array? Raid Adapter?

> The key factor to a high performance database is a high
> performance I/O system. If you look in the archives
you'll find people running postgresql on 30 and 40
> drive arrays.

I'll do a search, thank you.


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to