Re: How to avoid transaction ID wrap

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: How to avoid transaction ID wrap
Дата
Msg-id 4486BD22.9030901@sun.com
обсуждение исходный текст
Ответ на Re: How to avoid transaction ID wrap  (Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>)
Ответы Re: How to avoid transaction ID wrap  (Martijn van Oosterhout <kleptog@svana.org>)
Re: How to avoid transaction ID wrap  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Koichi Suzuki wrote:
> I've once proposed a patch for 64bit transaction ID, but this causes 
> some overhead to each tuple (XMIN and XMAX).   Pgbench with 64bit 
> transaction ID has to pay about a couple of percent of performance.   
> If 64bit transaction ID is a reasonable fix,  I've already posted this 
> patch.   Anyone can apply this to later versions.
Did you check performance on 32-bit or 64-bit systems and 64-bit binary 
version of PGSQL? I think that today is not problem to have 64-bit 
architecture and 64-bit ID should increase scalability of Postgres.
      Zdenek


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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: self-deadlock at FATAL exit of boostrap process on read error
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to avoid transaction ID wrap