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 AANLkTikFEyOOX2sWKB0vpCSeUKwaqo+vfTRJ_DMNTpcn@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.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
>
> Possibly the table's never been ANALYZEd ... do you have autovacuum
> enabled? =C2=A0If it has been analyzed reasonably recently, then it might=
 be
> necessary to crank up the statistics target to get a better estimate.
> It's difficult to give detailed advice when you haven't mentioned what
> PG version you're running.
>

I do have autovacuum enabled and I am running 8.4

autovacuum =3D on
vacuum_cost_limit =3D 150
log_autovacuum_min_duration =3D 0
autovacuum_max_workers =3D 4
autovacuum_naptime =3D 5min
autovacuum_vacuum_cost_delay =3D 30ms

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

Предыдущее
От: pasman pasmański
Дата:
Сообщение: Re: Problems with adding a is not null to a query.
Следующее
От: "Karsten Loesing"
Дата:
Сообщение: BUG #5840: Updating arrays using subscripted assignment results in uninitialized values