Re: Question about (lazy) vacuum
От | Hannu Krosing |
---|---|
Тема | Re: Question about (lazy) vacuum |
Дата | |
Msg-id | 1156338098.2961.30.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Question about (lazy) vacuum (Greg Stark <gsstark@mit.edu>) |
Список | pgsql-hackers |
Ühel kenal päeval, K, 2006-08-23 kell 08:11, kirjutas Greg Stark: > Hannu Krosing <hannu@skype.net> writes: > > BTW, I think that CONCURRENT CREATE INDEX should be modified to use long > > transactions which actually build the index and are ignored by vacuum > > and short ones which write data to system tables and are not ignored. > > That way we have one less obstacle for keeping high-update tables in > > shape. > > Hm, that might be worth thinking about. Note that it locks out vacuum from > running on the table it's running on so it would only help in allowing other > tables to be vacuumed effectively. Exactly. The whole point of one vacuum not blocking others is to make sure, that a vacuum on a huge table would not disable vacuuming and thereby reusing rows of much much smaller tables. Locking out vacuum on the table itself is ok, as the runtimes of vacuum and concurrent create index on a same table are in the same order. -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com
В списке pgsql-hackers по дате отправления: