Re: possible vacuum improvement? - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: possible vacuum improvement?
Date
Msg-id 006601c2531c$9ab9c210$6f01c00a@icomedias.com
Whole thread Raw
In response to Re: possible vacuum improvement?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: possible vacuum improvement?
Re: possible vacuum improvement?
List pgsql-hackers
> gets updated for each transaction but log table is just an insert. So
rather
> than vacumming entire db, just doing 'vacuum analyze accounts' give me
almost
> same results.
>

That is not really practicable, one datebase has 107 tables, and making a
cron job
with 107 vacuum calls is completly out of question and very error prone
anyway.

Regards,   Mario Weilguni




pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: possible vacuum improvement?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: possible vacuum improvement?