> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
