Re: Restriction on transaction size????

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Restriction on transaction size????
Дата
Msg-id 19483.1046878930@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Restriction on transaction size????  (David Ecker <david@ecker-software.de>)
Список pgsql-general
David Ecker <david@ecker-software.de> writes:
> how many querys can be executed inside one transaction??

2^32 - 1.

> It looks like after the commit that 20% of insert querys didn't actually
> got inserted (at 3500 querys in one transaction 2000 select, 1500 insert
> and only ) and the querys  are error free.

Dunno what your problem is, but it's not a matter of too many queries.

            regards, tom lane

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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: My employment with PeerDirect
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Help me!