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:10:08
Message-ID: AANLkTikOnktVgpOSNf98wPLnFg0GA12=S3aB2yLw5adv@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).
>

I started a manual VACUUM ANALYZE on the table. It's been running for
about an half hour now, The table gets quite busy so I am hoping there
is no real harm in letting go to the end.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tim Uckun 2011-01-16 22:47:10 Re: Problems with adding a is not null to a query.
Previous Message Tom Lane 2011-01-16 17:15:34 Re: Problems with adding a is not null to a query.