Re: Problems with adding a is not null to a query. - Mailing list pgsql-bugs

From Tim Uckun
Subject Re: Problems with adding a is not null to a query.
Date
Msg-id AANLkTikOnktVgpOSNf98wPLnFg0GA12=S3aB2yLw5adv@mail.gmail.com
Whole thread Raw
In response to Re: Problems with adding a is not null to a query.  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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. =C2=A0If not, you'll need to ra=
ise
> 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.

pgsql-bugs by date:

Previous
From: "Julien Demoor"
Date:
Subject: Re: BUG #5835: PL/Python crashes
Next
From: Tim Uckun
Date:
Subject: Re: Problems with adding a is not null to a query.