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

From Tom Lane
Subject Re: Help with count(*)
Date
Msg-id 3131.1068835799@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help with count(*)  (Hannu Krosing <hannu@tm.ee>)
List pgsql-performance
Hannu Krosing <hannu@tm.ee> writes:
> Christopher Browne kirjutas R, 14.11.2003 kell 16:13:
>> 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 is on the TODO list.  I looked at it briefly towards the end of the
7.4 development cycle, and decided that it was nontrivial and I didn't
have time to make it happen before beta started.  I don't recall why it
didn't seem trivial.

            regards, tom lane

pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Help with count(*)
Next
From: Will LaShell
Date:
Subject: Re: Help with count(*)