Re: slow query

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow query
Date: 2003-02-24 16:58:33
Message-ID: 1046105913.1014.66.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 2003-02-24 at 10:59, Oleg Lebedev wrote:
> Thanks everybody for your help.
> VACUUM FULL did the job, and now the query performance is the same in
> both databases. I am surprised that FULL option makes such a dramatic
> change to the query performance: from 4min. to 5sec.!!! It also changed
> planner stats from ~9 sec to ~8sec.

If your seeing wildly dramatic improvments from vacuum full, you might
want to look into running regular vacuums more often (especially for
high turnover tables), increase your max_fsm_relations to 1000, and
increasing your max_fsm_pages.

Robert Treat

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Oleg Lebedev 2003-02-24 17:07:03 Re: slow query
Previous Message Oleg Lebedev 2003-02-24 15:59:11 Re: slow query