Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange behaviour with a query - Mailing list pgsql-admin

From Tom Lane
Subject Re: Strange behaviour with a query
Date
Msg-id 20715.1239979038@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange behaviour with a query  (Iñigo Martinez Lasala <imartinez@vectorsf.com>)
List pgsql-admin
Tree view 
=?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com> writes:
> ANALYZE;
> And everything working like a charm....

> What is the reason for this to happen? Is it common?

It sounds like you might never have ANALYZEd the database at all, or
anyway not have done so recently.  Recommended practice is to ANALYZE
at least as often as you vacuum.  Or turn on autovacuum and let it
take care of it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Iñigo Martinez Lasala
Date:
Subject: Re: Strange behaviour with a query
Next
From: Enrico Weigelt
Date:
Subject: pg_dumpall + pgdump_oid table + incremental backup