On Mon, Jan 26, 2009 at 12:06 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> On Mon, Jan 26, 2009 at 3:04 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> On Sun, Jan 25, 2009 at 11:58 PM, Phoenix Kiula <phoenix.kiula@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.