Re: Problem with 7.4.1 and complicated queries - Mailing list pgsql-general

From Jonathan Weiss
Subject Re: Problem with 7.4.1 and complicated queries
Date
Msg-id fa91ff4704102413005ead5b36@mail.gmail.com
Whole thread Raw
In response to Problem with 7.4.1 and complicated queries  (Jonathan Weiss <joweiss@gmail.com>)
Responses Re: Problem with 7.4.1 and complicated queries
List pgsql-general
Hi!

>
> This sounds like maybe you're FSM settings aren't high enough, or you
> aren't analyzing your tables.

I doubled the values for max_fsm_pages and max_fsm_relations.

> Try vacuum full and analyze first, and see if that fixes the problem.
> If so, then you either need to vacuum more often, increase your fsm
> ssettings, (or both) and probably need to schedule regular analyzes.

I tried vacuum full and analyze, but the problem still remains. The
funny thing is, that working on a fresh dumped version works.


Greets,
Jonathan

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: '1 year' = '360 days' ????
Next
From: Tom Lane
Date:
Subject: Re: '1 year' = '360 days' ????