From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: new to postgres (and db management) and performance already a problem :-(
Date: Mon, 16 Jan 2006 17:42:45 -0500
Message-ID: <20060116224245.GE18743@phlogiston.dyndns.org> (raw)
In-Reply-To: <43CC1938.7020807@gmail.com>
References: <43CC1938.7020807@gmail.com>
On Mon, Jan 16, 2006 at 11:07:52PM +0100, Antoine wrote:
> performance problems (a programme running 1.5x slower than two weeks
> ago) might not be coming from the db (or rather, my maintaining of it).
> I have turned on stats, so as to allow autovacuuming, but have no idea
> whether that could be related. Is it better to schedule a cron job to do
> it x times a day? I just left all the default values in postgres.conf...
> could I do some tweaking?
The first thing you need to do is find out where your problem is.
Are queries running slowly? You need to do some EXPLAIN ANALYSE
queries to understand that.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
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: ajs@crankycanuck.ca
Subject: Re: new to postgres (and db management) and performance already a problem :-(
In-Reply-To: <20060116224245.GE18743@phlogiston.dyndns.org>
* 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