Re: Problem after VACUUM ANALYZE

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: mljv(at)planwerk6(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem after VACUUM ANALYZE
Date: 2008-04-08 16:38:30
Message-ID: dcc563d10804080938v3d142483rfe335da4c4e286dc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It sounds to me like two possible problems, maybe combined.

One possibility is that you have a data distribution that results in
statistics being gathered that don't really represent your data. Try
increasing the stats target for that column (or the whole db if you'd
rather) and re-running analyze.

The other possibility is that you've got some index bloat happening
and you might benefit from reindexing the problematic table.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-08 16:59:23 Re: tsvector_update_trigger throws error "column is not of tsvector type"
Previous Message Alan Hodgson 2008-04-08 16:30:12 Re: Problem after VACUUM ANALYZE