| From: | "Brian Modra" <epailty(at)googlemail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ideal server |
| Date: | 2008-10-17 21:19:28 |
| Message-ID: | 5a9699850810171419y5211dc08i10a0d8cd404d7345@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a server in production running postgresql, receiving 110 rows
inserted per second, with some pretty intense queries involving long
plpgsql.
This server has 4Gigs of RAM and dual processor. Disk is Raid 5.
I need more power, and am wondering what is the place really I need to put
more emphasis? CPU, RAM, or disk?
I'm thinking of a 4xCPU and 20 Gigs and one of those large ram disks which
has its own battery and writes all RAM to hard disk in the event of power
failure.
Obviously I need to first get a good sysadmin guy to configure postgres
properly, but I am sure I also need a bigger host.
Any advice will be appreciated.
Brian
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 183 8059
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Atkins | 2008-10-17 21:32:54 | Re: psql: what's the SQL to compute the ratio of table sizes? |
| Previous Message | Scott Marlowe | 2008-10-17 21:17:18 | Re: psql: what's the SQL to compute the ratio of table sizes? |