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