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 AANLkTikFEyOOX2sWKB0vpCSeUKwaqo+vfTRJ_DMNTpcn@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.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
>
> 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 by date:

Previous
From: pasman pasmański
Date:
Subject: Re: Problems with adding a is not null to a query.
Next
From: "Karsten Loesing"
Date:
Subject: BUG #5840: Updating arrays using subscripted assignment results in uninitialized values