From: Roman Neuhauser <neuhauser@sigpipe.cz>
To: Jonathan Sinclair <jonathan.sinclair@molevalleyfarmers.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Query response time
Date: Wed, 9 Aug 2006 17:24:56 +0000
Message-ID: <20060809172456.GH1973@dagan.sigpipe.cz> (raw)
In-Reply-To: <746457F7E51F3B4BB53A8447D7204B78E456@MVGMAIL.mvg.local>
References: <746457F7E51F3B4BB53A8447D7204B78E456@MVGMAIL.mvg.local>
# 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
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-sql@postgresql.org
Cc: neuhauser@sigpipe.cz, jonathan.sinclair@molevalleyfarmers.com
Subject: Re: Query response time
In-Reply-To: <20060809172456.GH1973@dagan.sigpipe.cz>
* 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