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
Karim Nassar wrote:
Thanks to all for the tips.
...
In general I would recommend RAID1, because that is the safe bet. If
your db is the bottleneck, and your data isn't all that critical, and
you are read heavy, I would probably go with RAID1, if you are write
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
scienti
Am Donnerstag, 10. März 2005 08:44 schrieb Karim Nassar:
> From rom http://www.powerpostgresql.com/PerfList/
>
> "even in a two-disk server, you can put the transaction log onto the
> operating system disk and reap some benefits."
>
> Context: I have a two disk server that is about to become dedica
Karim Nassar wrote:
From rom http://www.powerpostgresql.com/PerfList/
"even in a two-disk server, you can put the transaction log onto the
operating system disk and reap some benefits."
Context: I have a two disk server that is about to become dedicated to
postgresql (it's a sun v40z running gentoo
Karim Nassar wrote:
Context: I have a two disk server that is about to become dedicated to
postgresql (it's a sun v40z running gentoo linux).
What's "theoretically better"?
1) OS and pg_xlog on one disk, rest of postgresql on the other? (if I
understand the above correctly)
2) Everything stripe
From rom http://www.powerpostgresql.com/PerfList/
"even in a two-disk server, you can put the transaction log onto the
operating system disk and reap some benefits."
Context: I have a two disk server that is about to become dedicated to
postgresql (it's a sun v40z running gentoo linux).
What's "