From: Scott Marlowe <smarlowe@qwest.net>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: my boss want to migrate to ORACLE
Date: Fri, 30 Jul 2004 22:14:41 -0600
Message-ID: <1091247281.27159.726.camel@localhost.localdomain> (raw)
In-Reply-To: <m3llh1otri.fsf@wolfe.cbbrowne.com>
References: <1091156393.39517b44365bc@mail.coretech.co.nz>
<001f01c4763c$fcef40f0$4e00020a@develavoie>
<m3llh1otri.fsf@wolfe.cbbrowne.com>
On Fri, 2004-07-30 at 19:22, Christopher Browne wrote:
> After a long battle with technology, stephane.tessier@abovesecurity.com ("Stephane Tessier"), an earthling, wrote:
> > I think with your help guys I'll do it!
> >
> > I'm working on it!
> >
> > I'll work on theses issues:
> >
> > we have space for more ram(we use 2 gigs on possibility of 3 gigs)
>
> That _may_ help; not completely clear.
>
> > iowait is very high 98% --> look like postgresql wait for io access
>
> In that case, if you haven't got a RAID controller with battery backed
> cache, then that should buy you a BIG boost in performance. Maybe
> $1500 USD; that could be money FABULOUSLY well spent.
>
> > raid5 -->raid0 if i'm right raid5 use 4 writes(parity,data, etc) for each
> > write on disk
>
> I try to avoid talking about RAID levels, and leave them to others
> :-).
FYI, in a previous post on this topic, the original poster put up a top
output that showed the machine using 2 gigs of swap with 150 Meg for
kernel cache, and all the memory being used by a few postgresql
processes. The machine was simply configured to give WAY too much
memory to shared buffers and sort mem and this was likely causing the
big slowdown.
Adding a battery backed caching RAID controller and properly configuring
postgresql.conf should get him into the realm of reasonable performance.
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: smarlowe@qwest.net, cbbrowne@acm.org
Subject: Re: my boss want to migrate to ORACLE
In-Reply-To: <1091247281.27159.726.camel@localhost.localdomain>
* 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