From uva_ece@rediffmail.com Thu Dec 22 09:49:43 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D2A6A9DCCC1 for ; Thu, 22 Dec 2005 05:49:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52742-02 for ; Thu, 22 Dec 2005 05:49:44 -0400 (AST) X-Greylist: delayed 00:06:41.330888 by SQLgrey- Received: from rediffmail.com (unknown [202.54.124.152]) by postgresql.org (Postfix) with SMTP id 70C179DCC4D for ; Thu, 22 Dec 2005 05:49:38 -0400 (AST) Received: (qmail 26858 invoked by uid 510); 22 Dec 2005 09:42:53 -0000 Date: 22 Dec 2005 09:42:53 -0000 Message-ID: <20051222094253.26857.qmail@webmail7.rediffmail.com> Received: from unknown (203.199.211.113) by rediffmail.com via HTTP; 22 dec 2005 09:42:53 -0000 MIME-Version: 1.0 From: "uva raj" Reply-To: "uva raj" To: pgsql-admin@postgresql.org Subject: execute batch Content-type: multipart/alternative; boundary="Next_1135244573---0-202.54.124.152-26838" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.07 required=5 tests=[AWL=-0.120, DNS_FROM_RFC_ABUSE=0.479, HTML_IMAGE_ONLY_08=2.435, HTML_MESSAGE=0.001, HTML_SHORT_LINK_IMG_1=0.275, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 3.07 X-Spam-Level: *** X-Archive-Number: 200512/271 X-Sequence-Number: 19991 This is a multipart mime message --Next_1135244573---0-202.54.124.152-26838 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline =0Ai want to execute a batch with 1000 statements.=0Ais there any limit f= or number of statements or size.=0Aplease reveal.=0A=0A --Next_1135244573---0-202.54.124.152-26838 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

=0A 
=0Ai want to execute a batch with 1000 statements.
=0Ai= s there any limit for number of statements or size.
=0Aplease reveal.=0A
=0A=0A

=0A

=0A=0A --Next_1135244573---0-202.54.124.152-26838-- From zhouqq@cs.toronto.edu Fri Dec 23 21:22:54 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CD64C9DCD1F for ; Fri, 23 Dec 2005 17:22:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39624-06 for ; Fri, 23 Dec 2005 17:22:55 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id DC4199DCCD8 for ; Fri, 23 Dec 2005 17:22:52 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jBNLMpHt059051 for ; Fri, 23 Dec 2005 21:22:51 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jBNL3hAs083095 for pgsql-admin@postgresql.org; Fri, 23 Dec 2005 21:03:43 GMT (envelope-from news) From: "Qingqing Zhou" X-Newsgroups: pgsql.admin Subject: Re: execute batch Date: Fri, 23 Dec 2005 16:04:49 -0500 Organization: Hub.Org Networking Services Lines: 17 Message-ID: References: <20051222094253.26857.qmail@webmail7.rediffmail.com> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.401 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.039] X-Spam-Score: -1.401 X-Spam-Level: X-Archive-Number: 200512/304 X-Sequence-Number: 20024 ""uva raj"" 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