Re: execute batch - Mailing list pgsql-admin

From Qingqing Zhou
Subject Re: execute batch
Date
Msg-id dohonf$2h2b$1@news.hub.org
Whole thread Raw
In response to execute batch  ("uva raj" <uva_ece@rediffmail.com>)
List pgsql-admin
""uva raj"" <uva_ece@rediffmail.com> wrote

> i want to execute a batch with 1000 statements.
> is there any limit for number of statements or size.
> please reveal.

If you mean how many statements in a transaction is supportted, then the
de-facto limit depends on your statement resource consumption. There are
various resources limits of the system, eg. number of open fds, RAM size,
disk space ... If you statements are sane enough, then 1000 statements per
transaction is never a problem.

Regards,
Qingqing



pgsql-admin by date:

Previous
From: Alain Rodriguez Arias
Date:
Subject: Re: lo_ functions
Next
From: "sandhya"
Date:
Subject: reg:lseek&read ..pls