Re: limits

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: limits
Дата
Msg-id 874peysxam.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на limits  (luca.ciciriello@email.it)
Список pgsql-general
<luca.ciciriello@email.it> writes:

> Hi All.
> My question is simple and plain: Are there some limit in the number of
> database operations between a BEGIN statement and a COMMIT statement?

The most relevant limitation is that the whole body has to fit in 1GB.

You can also only execute 4 billion statements even if it's in a loop.
8.3 helps this by making most read-only operations not count.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's Slony Replication support!

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

Предыдущее
От: luca.ciciriello@email.it
Дата:
Сообщение: limits
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: stored procedures and dynamic queries