| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Michael Ben-Nes <miki(at)canaan(dot)co(dot)il> |
| Cc: | Alex <alex(at)meerkatsoft(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What HW / OS is recommeded |
| Date: | 2004-12-16 13:59:24 |
| Message-ID: | 41C194BC.20307@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Michael Ben-Nes wrote:
> I think and please correct me that Postgres loves RAM, the more the better.
Certainly for disk-cache.
> Any way RAID5 is awful with writing, go with RAID1 ( mirroring )
Raid 10 seems to be the consensus if you have enough disks. See the
archives of the performance list for plenty of discussion.
> I use Debian Sarge and im very happy.
Not sure it makes much difference performance-wise. I'd use whatever
flavour of Linux you have the most experience with.
> Perl is very slow, maybe you can use PHP ?
If your Perl is slower than your PHP, you need to get a better Perl
programmer ;-)
In any case, if your application is too slow for your database then all
the previous tuning is largely irrelevant.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Malcolm Warren | 2004-12-16 14:03:14 | Re: Serial column has suddenly stopped working |
| Previous Message | Geoffrey | 2004-12-16 13:59:06 | Re: What HW / OS is recommeded |