| From: | Hasnul Fadhly bin Hasan <hasnulfadhly(dot)h(at)mimos(dot)my> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Recommended Specs |
| Date: | 2004-12-02 00:20:14 |
| Message-ID: | 41AE5FBE.2010104@mimos.my |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
I was reading a lot on the specs that was used by those who runs
postgres. I was wondering is the a more structured method of
determining what is the required hardware specs? The project that i am
doing can populate about few millions records a day (worst case).
Based on what i read, this is what i guess
RAM - the more the better
postgresql.conf must be optimized
CPU - not sure if adding more CPU will really help unless i start to
create parrallel insert sessions.
Hard disks - ?? how do i actually check how much space this records take
on the hard drives?
optimized queries is a must
OS? linux? freebsd? solaris?
cpu type? sun sparc? intel? amd?
anything else?
Hasnul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Marlowe | 2004-12-02 01:35:32 | Re: Alternatives to Dell? |
| Previous Message | Steven Rosenstein | 2004-12-02 00:17:05 | Re: Alternatives to Dell? |