Re: BUG #8620: SELECT on Materialized View Fails to Use Index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jesse(dot)denardo(at)myfarms(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8620: SELECT on Materialized View Fails to Use Index
Date: 2013-11-23 17:53:24
Message-ID: 16769.1385229204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jesse(dot)denardo(at)myfarms(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jesse Denardo 2013-11-23 20:32:58 Re: BUG #8620: SELECT on Materialized View Fails to Use Index
Previous Message esh.debajit09 2013-11-23 15:06:28 BUG #8621: unable to run the stack wiard