Re: possible vacuum improvement?
Mario Weilguni <mweilguni@sime.com>
From: "Mario Weilguni" <mweilguni@sime.com>
To: <shridhar_daithankar@persistent.co.in>, <pgsql-hackers@postgresql.org>
Date: 2002-09-03T07:36:23Z
Lists: 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