Date: Wed, 9 Aug 2006 17:24:56 +0000
From: Roman Neuhauser <neuhauser@sigpipe.cz>
To: Jonathan Sinclair <jonathan.sinclair@molevalleyfarmers.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Query response time
Message-ID: <20060809172456.GH1973@dagan.sigpipe.cz>
References: <746457F7E51F3B4BB53A8447D7204B78E456@MVGMAIL.mvg.local>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <746457F7E51F3B4BB53A8447D7204B78E456@MVGMAIL.mvg.local>
User-Agent: Mutt/1.5.11

# jonathan.sinclair@molevalleyfarmers.com / 2006-08-08 13:25:47 +0100:
> I am using PostgresSQL 7.4 and having some serious performance issues.

> I am using tables that only contain approx 2GB of data.

> The install was performed by yum onto a RAID server using Centos. I am
> sure there is something fundamentally wrong for I can't believe that
> postgres would have the reputation it has based on the statistics I'm
> getting. Does anyone have any advice?

    You'll need to configure PostrgreSQL, the default settings seem
    to be tuned so that PostgreSQL starts even in very limited
    environments.

    http://www.postgresql.org/docs/8.1/static/runtime-config.html

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991