Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexpected query plan results - Mailing list pgsql-performance

From Robert Haas
Subject Re: Unexpected query plan results
Date
Msg-id 603c8f070905291434l73038ceet145061a650efb98e@mail.gmail.com
Whole thread Raw
In response to Re: Unexpected query plan results  (Anne Rosset <arosset@collab.net>)
List pgsql-performance
Tree view 
> When the query plan takes a wrong path, is it possible that it is because
> statistics have not been run or updated?

Yes.  If you are not using autovacuum, you need to ANALYZE regularly,
or bad things will happen to you.

...Robert

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Unexpected query plan results
Next
From: Anne Rosset
Date:
Subject: Re: Unexpected query plan results