Re: BUG #8620: SELECT on Materialized View Fails to Use Index - Mailing list pgsql-bugs

Thanks Tom, that did the trick.


--
Jesse Denardo


On Sat, Nov 23, 2013 at 12:53 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> jesse.denardo@myfarms.com writes:
> > Any idea why Postgres would fail to use the
> > index on one machine but not the other, for identical queries?
>
> The rowcount estimates are far from identical.  Maybe you've ANALYZEd the
> matview on one machine and not the other?  Could you have auto-analyze
> disabled on the second machine?
>
>                         regards, tom lane
>
>