Re: possible vacuum improvement?
От | Shridhar Daithankar |
---|---|
Тема | Re: possible vacuum improvement? |
Дата | |
Msg-id | 3D74B2B1.15282.4BEA5B11@localhost обсуждение исходный текст |
Ответ на | Re: possible vacuum improvement? ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
Ответы |
Re: possible vacuum improvement?
|
Список | pgsql-hackers |
On 3 Sep 2002 at 15:14, Christopher Kings-Lynne wrote: > > 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. Actually that's what I did. Update global transaction counter than trigger the vacuum from a spare thread. but having it in DB has advantages of centralisation. It's just a good to have kind of thing.. ByeShridhar -- "I don't know why, but first C programs tend to look a lot worse thanfirst programs in any other language (maybe except for fortran, but thenI suspect all fortran programs look like `firsts')"(By Olaf Kirch)
В списке pgsql-hackers по дате отправления: