Re: Problems with adding a is not null to a query.

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problems with adding a is not null to a query.
Date: 2011-01-16 22:47:10
Message-ID: AANLkTimFK6AWNo+k+RoMf3=4uu_iRcmTKtASwM3=eWO5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>
> Hmm, autovacuum *should* have been keeping track of things for you,
> but it might still be worth doing a manual ANALYZE against that table
> to see if the estimated rowcount changes.  If not, you'll need to raise
> the statistics target for that column (and again ANALYZE).

The analyze finished. I re-ran the explain it was still taking a very
long time. I stopped it eventually.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Turner 2011-01-17 10:34:29 BUG #5841: rank()+1 fails, 1+rank() succeeds
Previous Message Tim Uckun 2011-01-16 22:10:08 Re: Problems with adding a is not null to a query.