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 4BF09DAFA1 for ; Tue, 22 Nov 2005 09:01:12 -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 26784-06 for ; Tue, 22 Nov 2005 13:01:13 +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 5C9F9DA84D for ; Tue, 22 Nov 2005 09:01:05 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 22 Nov 2005 10:01:52 -0300 X-IronPort-AV: i="3.97,361,1125892800"; d="scan'208,217"; a="29985255:sNHT8382724964" Received: from alvh.no-ip.org (200.85.218.89) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4350159700527006 for pgsql-admin@postgresql.org; Tue, 22 Nov 2005 10:00:58 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 494A3C30B0D; Tue, 22 Nov 2005 10:00:58 -0300 (CLST) Resent-From: alvherre@surnet.cl Resent-Date: Tue, 22 Nov 2005 10:00:58 -0300 Resent-Message-ID: <20051122130058.GB5183@surnet.cl> Resent-To: pgsql-admin@postgresql.org X-Original-To: alvherre@alvh.no-ip.org Received: by alvh.no-ip.org (Postfix, from userid 1004) id EA885C408AD; Tue, 22 Nov 2005 09:48:04 -0300 (CLST) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by alvh.no-ip.org (Postfix) with ESMTP id 35AAFC30B06 for ; Tue, 22 Nov 2005 09:48:02 -0300 (CLST) Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by hosting.commandprompt.com (8.13.4/8.13.4) with SMTP id jAMCg3JH029155 for ; Tue, 22 Nov 2005 04:42:05 -0800 Received: (qmail 11400 invoked by uid 507); 22 Nov 2005 12:40:55 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.0.3. Clear:RC:0(202.140.41.205):SA:0(-99.4/5.0):. Processed in 5.062651 secs); 22 Nov 2005 12:40:55 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 22 Nov 2005 12:40:49 -0000 Received: (qmail 17918 invoked by uid 504); 22 Nov 2005 12:39:26 -0000 Received: from yogvinder@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.86):. Processed in 3.203022 secs); 22 Nov 2005 12:39:26 -0000 Received: from unknown (HELO ng3054) (192.168.5.86) by ngmail.newgen.co.in with SMTP; 22 Nov 2005 12:39:23 -0000 Message-ID: <00b801c5ef61$7f711230$5605a8c0@ng3054> From: "Yogvinder Singh" To: "Alvaro Herrera" References: <006901c5ef4a$bc1c8050$5605a8c0@ng3054> <20051122120500.GA8685@surnet.cl> Subject: Re: Max no of commands per transaction Date: Tue, 22 Nov 2005 18:07:27 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B5_01C5EF8F.99001B50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Greylist: Delayed for 00:06:24 by milter-greylist-1.6 (hosting.commandprompt.com [192.168.1.101]); Tue, 22 Nov 2005 04:42:07 -0800 (PST) X-Bogosity: Ham, tests=bogofilter, spamicity=0.000000, version=0.96.6 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.712 required=5 tests=[AWL=-3.472, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, HTML_MESSAGE=0.001, RCVD_IN_NJABL_PROXY=0.327, RCVD_IN_SORBS_SOCKS=1.823, RCVD_IN_XBL=3.114] X-Spam-Score: 3.712 X-Spam-Level: *** X-Archive-Number: 200511/301 X-Sequence-Number: 19674 This is a multi-part message in MIME format. ------=_NextPart_000_00B5_01C5EF8F.99001B50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Atleast i want to know where is this setting for Max no of commands per = transaction ----- Original Message -----=20 From: "Alvaro Herrera" To: "Yogvinder Singh" Cc: Sent: Tuesday, November 22, 2005 5:35 PM Subject: Re: [ADMIN] Max no of commands per transaction > 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... >=20 > 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? >=20 > 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. >=20 > --=20 > Alvaro Herrera = http://www.CommandPrompt.com/ > The PostgreSQL Company - Command Prompt, Inc. > ------=_NextPart_000_00B5_01C5EF8F.99001B50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Atleast i want to know where is this = setting for=20 Max no of commands per transaction
 
 
----- Original Message -----
From: "Alvaro Herrera" <alvherre@commandprompt.com>
To: "Yogvinder Singh" <yogvinder@newgen.co.in>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, November 22, 2005 5:35=20 PM
Subject: Re: [ADMIN] Max no of commands = per=20 transaction

> Yogvinder Singh wrote:
> > hi,
>=20 >     i am getting an error "ERROR:  You may = only=20 have 2^32-1 commands per transaction".
> = >     Can=20 anyone tell where this size 2^32-1 is specified....
>=20 >     I want to reduce this size...
> =
> I=20 doubt you can reduce it without causing problems for the system,
> = because=20 some commands use more than one "command" internally.  = Exactly
> what=20 are you planning to do with it?
>
> It would actually be = trivial to=20 put a lower limit (see the
> CommandCounterIncrement function -- = you'll=20 have to recompile), but I
> guess I don't see the point.
> =
>=20 --
> Alvaro=20 Herrera           =             &= nbsp;       =20
http://www.CommandPrompt.com/
>=20 The PostgreSQL Company - Command Prompt, Inc.
> =
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, coping, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unlessthe sender does so expressly with due authority of Newgen Software TechnologiesLtd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_00B5_01C5EF8F.99001B50--