pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Will LaShell <will@lashell.net>
To: Hannu Krosing <hannu@tm.ee>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help with count(*)
Date: Fri, 14 Nov 2003 12:40:23 -0700
Message-ID: <3FB52FA7.8060508@lashell.net> (raw)
In-Reply-To: <1068831807.2540.44.camel@fuji.krosing.net>
References: <200311141251.38786.mallah@trade-india.com>
	<m3ad6zkpgj.fsf@wolfe.cbbrowne.com>
	<1068831807.2540.44.camel@fuji.krosing.net>

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




view thread (12+ messages)  latest in thread

Message-ID: <3FB52FA7.8060508@lashell.net>
Permalink:  ../3FB52FA7.8060508@lashell.net/
Also on:    postgresql.org/message-id/3FB52FA7.8060508@lashell.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: will@lashell.net, hannu@tm.ee, cbbrowne@acm.org
  Subject: Re: Help with count(*)
  In-Reply-To: <3FB52FA7.8060508@lashell.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox