On Mon, Jan 26, 2009 at 12:06 AM, Phoenix Kiula <phoenix.ki...@gmail.com> wrote: > On Mon, Jan 26, 2009 at 3:04 PM, Scott Marlowe <scott.marl...@gmail.com> > wrote: >> On Sun, Jan 25, 2009 at 11:58 PM, Phoenix Kiula <phoenix.ki...@gmail.com> >> wrote: >>> Hi Scott. Yes, there is an autovacuum on both the tables. Should i >>> additionally do a manual vacuum too? >> >> Nah, just an analyze. what version of pgsql is this, btw? >> > > > Actually both vacuum and analyze happen at regular intervals. Are they > not doing their job?
Hard to say. You could try increasing your stats target on the fields where the approximation is way off. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
