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

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Problems with adding a is not null to a query.
Дата
Msg-id AANLkTimFK6AWNo+k+RoMf3=4uu_iRcmTKtASwM3=eWO5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problems with adding a is not null to a query.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Problems with adding a is not null to a query.  (Robert Haas <robertmhaas@gmail.com>)
Список 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).


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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: Problems with adding a is not null to a query.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Problems with adding a is not null to a query.