Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group