Re: execute batch

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: execute batch
Date: 2005-12-23 21:04:49
Message-ID: dohonf$2h2b$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


""uva raj"" <uva_ece(at)rediffmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message sandhya 2005-12-26 08:17:04 Re: lo_ functions
Previous Message Qingqing Zhou 2005-12-23 20:58:08 Re: Need Suggestion about new version of PostgresSQL 8.1