From: markir@coretech.co.nz
To: Stephane Tessier <stephane.tessier@abovesecurity.com>
Cc: Scott Marlowe <smarlowe@qwest.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: my boss want to migrate to ORACLE
Date: Tue, 3 Aug 2004 10:47:18 +1200
Message-ID: <1091486838.923c2b71c3ae6@mail.coretech.co.nz> (raw)
In-Reply-To: <004b01c478d6$47f46530$4e00020a@develavoie>
References: <004b01c478d6$47f46530$4e00020a@develavoie>
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.tessier@abovesecurity.com>:
> I checked and we have a 128 megs battery backed cache on the raid
> controller...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@coretech.co.nz, stephane.tessier@abovesecurity.com, smarlowe@qwest.net
Subject: Re: my boss want to migrate to ORACLE
In-Reply-To: <1091486838.923c2b71c3ae6@mail.coretech.co.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox