X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 976C0DA84D for ; Tue, 22 Nov 2005 08:04:33 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99534-05 for ; Tue, 22 Nov 2005 12:04:34 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by svr1.postgresql.org (Postfix) with ESMTP id A6E53D7B79 for ; Tue, 22 Nov 2005 08:04:29 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 22 Nov 2005 09:05:25 -0300 X-IronPort-AV: i="3.97,361,1125892800"; d="scan'208"; a="29963509:sNHT109565616" Received: from alvh.no-ip.org (216.155.78.23) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4350159700525207; Tue, 22 Nov 2005 09:04:31 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 23BD9C30B0D; Tue, 22 Nov 2005 09:05:01 -0300 (CLST) Date: Tue, 22 Nov 2005 09:05:01 -0300 From: Alvaro Herrera To: Yogvinder Singh Cc: pgsql-admin@postgresql.org Subject: Re: Max no of commands per transaction Message-ID: <20051122120500.GA8685@surnet.cl> Mail-Followup-To: Yogvinder Singh , pgsql-admin@postgresql.org References: <006901c5ef4a$bc1c8050$5605a8c0@ng3054> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <006901c5ef4a$bc1c8050$5605a8c0@ng3054> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.819 required=5 tests=[AWL=0.492, RCVD_IN_NJABL_PROXY=0.327] X-Spam-Score: 0.819 X-Spam-Level: X-Archive-Number: 200511/299 X-Sequence-Number: 19672 Yogvinder Singh wrote: > hi, > i am getting an error "ERROR: You may only have 2^32-1 commands per transaction". > Can anyone tell where this size 2^32-1 is specified.... > I want to reduce this size... I doubt you can reduce it without causing problems for the system, because some commands use more than one "command" internally. Exactly what are you planning to do with it? It would actually be trivial to put a lower limit (see the CommandCounterIncrement function -- you'll have to recompile), but I guess I don't see the point. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.