Re: possible vacuum improvement?
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: <shridhar_daithankar@persistent.co.in>, <pgsql-hackers@postgresql.org>
Date: 2002-09-03T07:14:23Z
Lists: pgsql-hackers
> Personally I would prefer to have a trigger on a metadata table > where I could > trigger vacuuming a particular table each n number of > transactions(Oh it would > be great if that vacuum runs in background not blocking meta data > table.. just > a wishlist...). Can anybody tell me which table I could write > such a trigger? I > went thr. pg_* for some time but didn't find what I was looking for.. Actually, if you wrote it in C and kept some static data on each table, you could probably write a vacuum trigger pretty easily. You could even keep the info in a table. Chris