Re: Problem after VACUUM ANALYZE - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Problem after VACUUM ANALYZE
Date
Msg-id dcc563d10804080938v3d142483rfe335da4c4e286dc@mail.gmail.com
Whole thread Raw
In response to Problem after VACUUM ANALYZE  (mljv@planwerk6.de)
Responses Re: Problem after VACUUM ANALYZE  (mljv@planwerk6.de)
List 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.

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Problem after VACUUM ANALYZE
Next
From: Tom Lane
Date:
Subject: Re: tsvector_update_trigger throws error "column is not of tsvector type"