Re: Hot standby and removing VACUUM FULL

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Hot standby and removing VACUUM FULL
Дата
Msg-id 1259919027.13774.37808.camel@ebony
обсуждение исходный текст
Ответ на Re: Hot standby and removing VACUUM FULL  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Fri, 2009-12-04 at 11:22 +0200, Heikki Linnakangas wrote:

> Could you just mark the transaction as committed when you see the 1st
> commit record, but leave the XID in the known-assigned list and not
> release locks? That would emulate pretty closely what happens in the master.

OK, works for me. Thanks.

I thought of that before and dismissed it, clearly before my morning
coffee, but it works because we still hold the lock on the table so
nobody can actually read the now visible new rows. Cool.

-- Simon Riggs           www.2ndQuadrant.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Hot standby and removing VACUUM FULL
Следующее
От: decibel
Дата:
Сообщение: Re: Block-level CRC checks