pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.




view thread (19+ messages)  latest in thread

Message-ID: <1091247281.27159.726.camel@localhost.localdomain>
Permalink:  ../1091247281.27159.726.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1091247281.27159.726.camel@localhost.localdomain

 · 

reply

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