Re: Dead Space Map
От | Hannu Krosing |
---|---|
Тема | Re: Dead Space Map |
Дата | |
Msg-id | 1141143005.3864.1.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Dead Space Map (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Dead Space Map
|
Список | pgsql-hackers |
Ühel kenal päeval, T, 2006-02-28 kell 10:26, kirjutas Tom Lane: > Hannu Krosing <hannu@skype.net> writes: > > There is no fundamental reason, why vacuum needs to run in a transaction > > itselt. > > I'll just take one point: you cannot hold locks unless you have a > transaction, therefore you cannot even look up the catalog info about > the table you wish to vacuum; let alone prevent someone else from > dropping the table under you. > > The current bgwriter is incapable of looking at catalog contents as > such --- it operates only at the level of physical data blocks. Would'nt it still be possible to drop a table from below bgwriter ? Or will pgwriter just ignore that. -------------- Hannu
В списке pgsql-hackers по дате отправления: