Re: Pre-set Hint bits/VACUUM FREEZE on data load..?

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Pre-set Hint bits/VACUUM FREEZE on data load..?
Дата
Msg-id AANLkTimjH=Xrz2A1r=dmB9j38-QuHnHZj3-BGMBwcM3c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pre-set Hint bits/VACUUM FREEZE on data load..?  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Pre-set Hint bits/VACUUM FREEZE on data load..?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Fri, Mar 25, 2011 at 3:29 PM, Greg Stark <gsstark@mit.edu> wrote:
> On Fri, Mar 25, 2011 at 7:06 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>>> 1. The table has been created or truncated in the same transaction
>>,,,
>> That's not enough... some other transaction could see the data before
>> the transaction commits.
>
> How?

Hmm.  Maybe I'm wrong.  I guess the XID would still be in the MVCC
snapshot of every other running transaction, so maybe it would be OK.
*scratches head*

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP: Allow SQL-language functions to reference parameters by parameter name
Следующее
От: Robert Haas
Дата:
Сообщение: Re: SSI bug?