Postgres Pro
Downloads
Home   >   mailing lists

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 AANLkTimFK6AWNo+k+RoMf3=4uu_iRcmTKtASwM3=eWO5@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>)
Responses Re: Problems with adding a is not null to a query.
List pgsql-bugs
Tree view 
>
> 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).


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

pgsql-bugs by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Problems with adding a is not null to a query.
Next
From: Robert Haas
Date:
Subject: Re: Problems with adding a is not null to a query.