pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Hardware impact on performances 2+ messages / 2 participants [nested] [flat]
* Hardware impact on performances @ 2005-03-14 11:54 Camille Chafer <camille@ankama.com> 2005-03-21 09:55 ` Re: Hardware impact on performances Richard Huxton <dev@archonet.com> 0 siblings, 1 reply; 2+ messages in thread From: Camille Chafer @ 2005-03-14 11:54 UTC (permalink / raw) To: pgsql-performance Hi, I'm using PostgreSQL 8 for a mmorpg. The part of each operation is : select: 50%, update: 40%, insert: 10%. I have no more than 4-5 concurrent connections to the database, but each of them does A LOT of queries (several per second). The database size is about 1GB, but it'll probably be around 2GB in a fews months. The OS will be FreeBSD (version production 5.3 probably, or 4.10) At this time, i'm looking for a new server. Before to buy it, I grab some informations.. So, my question is : what would be the best hardware for this type of needs ? Of course, I'm not asking for a trademark and/or for prices, but for hints. - What is the most important part of the system : CPU ? RAM ? Disks ? - Is a server with 2 or more CPUs much better than a server with a single one, for a pgsql database ? - How much RAM do I need ? The size of the data ? Twice the size ? - I heard Raid1+0 is better than Raid 5. Is it right ? What would be the best configuration, regarding performances and security ? - Does the CPU type (i386, PowerPC, ....) matters ? - A lot of queries probably generate a lot of network output. Does the network controller matters ? - And finally, last question : is it possible to run a single postgresql database on several servers ? (hardware clustering) Thanks in advance for your answers, and sorry for my crap english (i'm french). Camille Chafer ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Hardware impact on performances 2005-03-14 11:54 Hardware impact on performances Camille Chafer <camille@ankama.com> @ 2005-03-21 09:55 ` Richard Huxton <dev@archonet.com> 0 siblings, 0 replies; 2+ messages in thread From: Richard Huxton @ 2005-03-21 09:55 UTC (permalink / raw) To: Camille Chafer <camille@ankama.com>; +Cc: pgsql-performance Camille Chafer wrote: > Hi, > > I'm using PostgreSQL 8 for a mmorpg. > The part of each operation is : select: 50%, update: 40%, insert: 10%. > I have no more than 4-5 concurrent connections to the database, but each > of them does A LOT of queries (several per second). > The database size is about 1GB, but it'll probably be around 2GB in a > fews months. > The OS will be FreeBSD (version production 5.3 probably, or 4.10) > > At this time, i'm looking for a new server. Before to buy it, I grab > some informations.. > So, my question is : what would be the best hardware for this type of > needs ? > Of course, I'm not asking for a trademark and/or for prices, but for hints. > > - What is the most important part of the system : CPU ? RAM ? Disks ? Usually Disks/RAM. Since you've got a lot of updates/inserts, battery-backed write-cache on your raid controller would be good. > - Is a server with 2 or more CPUs much better than a server with a > single one, for a pgsql database ? With 2+ connections, each can be serviced by one CPU. Of course, if your disk I/O is saturated then it won't help. > - How much RAM do I need ? The size of the data ? Twice the size ? Ideally, enough to hold your "working set". That is, enough cache to store all pages/indexes you regularly access. > - I heard Raid1+0 is better than Raid 5. Is it right ? What would be the > best configuration, regarding performances and security ? It can depend - check the list archives for a lot of discussion on this. More disks is always better. > - Does the CPU type (i386, PowerPC, ....) matters ? Dual-Xeons have given problems. A lot of people seem to think Opteron-based systems provide good value. > - A lot of queries probably generate a lot of network output. Does the > network controller matters ? Well, obviously the more time spent handling network I/O, the less time you spend running queries. I'd think it would have to be a *lot* of activity to make a serious difference. > - And finally, last question : is it possible to run a single postgresql > database on several servers ? (hardware clustering) Not easily, and it probably wouldn't provide any performance benefit. Plenty of replication options though. > Thanks in advance for your answers, and sorry for my crap english (i'm > french). Your English is perfect. -- Richard Huxton Archonet Ltd ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-21 09:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-03-14 11:54 Hardware impact on performances Camille Chafer <camille@ankama.com> 2005-03-21 09:55 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox