Re: Problem with 7.4.1 and complicated queries

From: Jonathan Weiss <joweiss(at)gmail(dot)com>
To: Scott Marlowe <smarlowe(at)qwest(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with 7.4.1 and complicated queries
Date: 2004-10-24 20:00:09
Message-ID: fa91ff4704102413005ead5b36@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-24 20:41:33 Re: '1 year' = '360 days' ????
Previous Message jbi130 2004-10-24 17:49:25 Memory exhausted on DELETE.