Re: Help with count(*) - Mailing list pgsql-performance

From Hannu Krosing
Subject Re: Help with count(*)
Date
Msg-id 1068831807.2540.44.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Help with count(*)  (Christopher Browne <cbbrowne@acm.org>)
Responses Re: Help with count(*)
Re: Help with count(*)
List pgsql-performance
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 ?

------------
Hannu


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query question
Next
From: Tom Lane
Date:
Subject: Re: Help with count(*)