| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Karim Nassar <Karim(dot)Nassar(at)acm(dot)org> |
| Cc: | John A Meinel <john(at)arbash-meinel(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: What's better: Raid 0 or disk for seperate pg_xlog |
| Date: | 2005-03-11 08:05:57 |
| Message-ID: | 42315165.1050202@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Karim Nassar wrote:
> Thanks to all for the tips.
>
> On Thu, 2005-03-10 at 09:26 -0600, John A Meinel wrote:
>
>>How critical is your data? How update heavy versus read heavy, etc are you?
>
>
> Large, relatively infrequent uploads, with frequent reads. The
> application is a web front-end to scientific research data. The
> scientists have their own copy of the data, so if something went really
> bad, we could probably get them to upload again.
If you have very few updates and your reads aren't mostly from RAM you
could be better off with simply mirroring (assuming that gains you read
bandwidth). Failing that, use the tablespace feature to balance your
read load as far as you can.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hugo Ferreira | 2005-03-11 11:53:18 | Statistics not working?? |
| Previous Message | John Arbash Meinel | 2005-03-10 19:56:03 | Re: What's better: Raid 0 or disk for seperate pg_xlog |