Re: PostgreSQL 64 Bit XIDs - Transaction IDs

Поиск
Список
Период
Сортировка
От Gerhard Wiesinger
Тема Re: PostgreSQL 64 Bit XIDs - Transaction IDs
Дата
Msg-id alpine.LFD.2.02.1203232012240.10155@bbs.intern
обсуждение исходный текст
Ответ на Re: PostgreSQL 64 Bit XIDs - Transaction IDs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Fri, 23 Mar 2012, Tom Lane wrote:

> Merlin Moncure <mmoncure@gmail.com> writes:
>> On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger <lists@wiesinger.com> wrote:
>>> So I think XID overflow should be planned for one of the next PostgreSQL
>>> releases.
>
>> two mitigating factors:
>> 1. read only transactions do not increment xid counter
>
> Yes.  Ask your admin what his throughput of *data modifying*
> transactions is.  I'll bet that number is a few orders of magnitude
> smaller again.

That were all small writing transactions benchmarking the database (with
the corrected values discussed).

Ciao,
Gerhard

--
http://www.wiesinger.com/

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

Предыдущее
От: Gerhard Wiesinger
Дата:
Сообщение: Re: PostgreSQL 64 Bit XIDs - Transaction IDs
Следующее
От:
Дата:
Сообщение: Change the default [tgenabled] for new "internal" triggers ?