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

From: Jesse Denardo <jesse(dot)denardo(at)myfarms(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8620: SELECT on Materialized View Fails to Use Index
Date: 2013-11-23 20:32:58
Message-ID: CANiVXAiy5nDP_=4z16ydiZZt0N065Un8aZuYOGOAdV5VcTy6TQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks Tom, that did the trick.

--
Jesse Denardo

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

> 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-11-23 20:39:39 Re: Server may segfault when using slices on int2vector
Previous Message Tom Lane 2013-11-23 17:53:24 Re: BUG #8620: SELECT on Materialized View Fails to Use Index