Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #8620: SELECT on Materialized View Fails to Use Index
Date
Msg-id 16769.1385229204@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8620: SELECT on Materialized View Fails to Use Index  (jesse.denardo@myfarms.com)
Responses Re: BUG #8620: SELECT on Materialized View Fails to Use Index  (Jesse Denardo <jesse.denardo@myfarms.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: esh.debajit09@gmail.com
Date:
Subject: BUG #8621: unable to run the stack wiard
Next
From: Jesse Denardo
Date:
Subject: Re: BUG #8620: SELECT on Materialized View Fails to Use Index