Re: Exposing the Xact commit order to the user

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Exposing the Xact commit order to the user
Дата
Msg-id 4BFC2BD6.704@Yahoo.com
обсуждение исходный текст
Ответ на Re: Exposing the Xact commit order to the user  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Exposing the Xact commit order to the user  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 5/24/2010 9:30 AM, Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> 
> 
>> In light of the proposed purging scheme, how would it be able to distinguish 
>> between those two cases (nothing there yet vs. was there but purged)?
> 
>> There is a difference between an empty result set and an exception.
> 
> No, I meant how will the *function* know, if a superuser and/or some 
> background process can purge records at any time?

The data contains timestamps which are supposedly taken in commit order. 
Checking the age of the last entry in the file should be simple enough 
to determine if the segment matches the "max age" configuration (if 
set). In the case of a superuser telling what to purge he would just 
call a function with a serial number (telling the obsolete segments).


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Exposing the Xact commit order to the user
Следующее
От: Tom Lane
Дата:
Сообщение: mergejoin null handling (was Re: [PERFORM] merge join killing performance)