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 3B953D1B51E for ; Fri, 14 Nov 2003 14:49:26 +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 97934-05 for ; Fri, 14 Nov 2003 10:48:58 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id C557AD1B540 for ; Fri, 14 Nov 2003 10:48:54 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hAEEmsNu027454 for ; Fri, 14 Nov 2003 14:48:54 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hAEEKNmv021905 for pgsql-performance@postgresql.org; Fri, 14 Nov 2003 14:20:23 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Help with count(*) Date: Fri, 14 Nov 2003 09:13:48 -0500 Organization: cbbrowne Computing Inc Lines: 19 Message-ID: References: <200311141251.38786.mallah@trade-india.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:+5cNivcH5pqcGL+Z9tMQuNk0Vto= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/109 X-Sequence-Number: 4669 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... -- If this was helpful, rate me http://cbbrowne.com/info/multiplexor.html "Waving away a cloud of smoke, I look up, and am blinded by a bright, white light. It's God. No, not Richard Stallman, or Linus Torvalds, but God. In a booming voice, He says: "THIS IS A SIGN. USE LINUX, THE FREE Unix SYSTEM FOR THE 386." -- Matt Welsh