| From: | markir(at)coretech(dot)co(dot)nz |
|---|---|
| To: | Stephane Tessier <stephane(dot)tessier(at)abovesecurity(dot)com> |
| Cc: | 'Scott Marlowe' <smarlowe(at)qwest(dot)net>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: my boss want to migrate to ORACLE |
| Date: | 2004-08-02 22:47:18 |
| Message-ID: | 1091486838.923c2b71c3ae6@mail.coretech.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
It may be worth pricing up expansion options e.g. 256M or more.
The other path to consider is changing RAID5 -> RAID10 if your card supports it.
However, I would recommend reducing that shared_buffers setting and doing your
performance measurements *again* - before changing anything else. This is
because you want to ensure that all your io hammering is not just because you
are making the machine swap (by giving postgres too much memory as Scott
mentioned)!
Quoting Stephane Tessier <stephane(dot)tessier(at)abovesecurity(dot)com>:
> I checked and we have a 128 megs battery backed cache on the raid
> controller...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2004-08-03 00:17:16 | Re: my boss want to migrate to ORACLE |
| Previous Message | Gaetano Mendola | 2004-08-02 22:13:56 | Re: Page Miss Hits |