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

From Christopher Kings-Lynne
Subject Re: possible vacuum improvement?
Date
Msg-id GNELIHDDFBOCMGBFGEFOIEAICEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: possible vacuum improvement?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: possible vacuum improvement?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List 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



pgsql-hackers by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: possible vacuum improvement?
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: possible vacuum improvement?