X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 26C03D1B4E4 for ; Fri, 14 Nov 2003 19:41:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51358-10 for ; Fri, 14 Nov 2003 15:40:30 -0400 (AST) Received: from jwilhelm.ofsloans.com (unknown [209.180.142.225]) by svr1.postgresql.org (Postfix) with ESMTP id 78FE8D1B50B for ; Fri, 14 Nov 2003 15:40:28 -0400 (AST) Message-ID: <3FB52FA7.8060508@lashell.net> Date: Fri, 14 Nov 2003 12:40:23 -0700 From: Will LaShell X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hannu Krosing Cc: Christopher Browne , pgsql-performance@postgresql.org Subject: Re: Help with count(*) References: <200311141251.38786.mallah@trade-india.com> <1068831807.2540.44.camel@fuji.krosing.net> In-Reply-To: <1068831807.2540.44.camel@fuji.krosing.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/117 X-Sequence-Number: 4677 Hannu Krosing wrote: >Christopher Browne kirjutas R, 14.11.2003 kell 16:13: > > >>Martha Stewart called it a Good Thing when mallah@trade-india.com (Rajesh Kumar Mallah) wrote: >> >> >>>INFO: "profiles": found 0 removable, 369195 nonremovable row versions in 43423 pages >>>DETAIL: 246130 dead row versions cannot be removed yet. >>>Nonremovable row versions range from 136 to 2036 bytes long. >>> >>> >>It seems as though you have a transaction open that is holding onto a >>whole lot of old rows. >> >>I have seen this happen somewhat-invisibly when a JDBC connection >>manager opens transactions for each connection, and then no processing >>happens to use those connections for a long time. The open >>transactions prevent vacuums from doing any good... >> >> > >Can't the backend be made to delay the "real" start of transaction until >the first query gets executed ? > > That seems counter intuitive doesn't it? Why write more code in the server when the client is the thing that has the problem? Will