Re: [HACKERS] Another way to reduce pg_subtrans lookup overhead

2005-12-01 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I thought of a different approach to it, which is to make snapshot >> checking take a hint from TransactionIdIsInProgress: use the subxid >> caches from the PG_PROC array. > Yeah, I had thought about using the XidCache while checking

Re: [HACKERS] Another way to reduce pg_subtrans lookup overhead

2005-12-01 Thread Alvaro Herrera
Tom Lane wrote: > I mentioned yesterday that I'm looking at the problem of excessive > accesses to pg_subtrans when there is an old open transaction: > http://archives.postgresql.org/pgsql-hackers/2005-11/msg01547.php > > I thought of a different approach to it, which is to make snapshot > checkin

[HACKERS] Another way to reduce pg_subtrans lookup overhead

2005-11-30 Thread Tom Lane
I mentioned yesterday that I'm looking at the problem of excessive accesses to pg_subtrans when there is an old open transaction: http://archives.postgresql.org/pgsql-hackers/2005-11/msg01547.php I thought of a different approach to it, which is to make snapshot checking take a hint from Transacti