Re: new to postgres (and db management) and performance already a problem :-( - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: new to postgres (and db management) and performance already a problem :-(
Date
Msg-id 20060116224245.GE18743@phlogiston.dyndns.org
Whole thread Raw
In response to new to postgres (and db management) and performance already a problem :-(  (Antoine)
List pgsql-performance
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  | 
The whole tendency of modern prose is away from concreteness.
        --George Orwell

pgsql-performance by date:

Previous
From: Antoine
Date:
Subject: new to postgres (and db management) and performance already a problem :-(
Next
From: Tom Lane
Date:
Subject: Re: new to postgres (and db management) and performance already a problem :-(