| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | bpalmer <bpalmer(at)crimelabs(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to make a REALLY FAST db server? |
| Date: | 2001-09-10 20:03:37 |
| Message-ID: | 200109102003.f8AK3ba24240@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I'm looking to make a DB server for a project I'm working on (using pgsql)
> and am wondering if people have suggestions?
>
> Thoughts:
>
> - Hardware: dual / quad Intel class
OK, but remember I/O is key for databases. The more spindles the
better. See my performance article on techdocs.
> - OS: Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
> can do multi proc support
I would recommend soft updates be enabled.
> - Disk: SCSI Raid 1+0
Not sure about that. Is that optimal for I/O?
> - Ram: Not really sure here. Is there math somewhere for ram needs for
> pgsql? I imagine is has something to do with # connections, db size,
> etc.
Again, see article.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | B. Palmer | 2001-09-10 20:17:11 | Re: How to make a REALLY FAST db server? |
| Previous Message | Lynn Holt | 2001-09-10 19:57:26 | pg_dump problem |