Re: Unexpected query plan results

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Anne Rosset <arosset(at)collab(dot)net>
Cc: Dave Dutcher <dave(at)tridecap(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Unexpected query plan results
Date: 2009-05-29 21:34:02
Message-ID: 603c8f070905291434l73038ceet145061a650efb98e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Anne Rosset 2009-05-29 21:57:30 Re: Unexpected query plan results
Previous Message Robert Haas 2009-05-29 21:32:54 Re: Unexpected query plan results