Skip site navigation (1) Skip section navigation (2)

Re: pgsql/src/backend/access/transam (xact.c)

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql/src/backend/access/transam (xact.c)
Date: 2000-11-10 00:55:36
Message-ID: 200011100055.TAA20264@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-committers
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > I thought there were some cases where looking up the index on pg_index
> > lead to an infinite recursion.  Maybe that is gone now.
> 
> No, that behavior is still there, and the special-case code for it
> is still there in catcache.c (I did try taking it out just to see
> what would happen ... sure 'nuff, infinite recursion).

OK, I understand.

> 
> But the routines in indexing.c weren't bringing anything to the party,
> except for a restatement of the scankeys needed for various system
> indexes.  And the syscache has that same info already.  Everytime we did
> a tuple fetch for a syscache, the routine in indexing.c was redoing
> ScanKeyEntryInitialize() calls to recompute the same scankey information
> already present in the syscache.  Waste of time, particularly the
> fmgr_info() call.
> 
> I left a couple of the indexing.c routines in place because there were
> hardwired calls to them in relcache.c.  But most of them aren't needed,
> and they certainly aren't valuable enough to expect people to make
> another one everytime they make a new syscache ...

Yes, I see that now.  Very nice.  It was a pain to update for new
caches.


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-committers by date

Next:From: Bruce Momjian - CVSDate: 2000-11-10 02:27:27
Subject: [WEBMASTER] 'www/html/users-lounge index.html'
Previous:From: Tom LaneDate: 2000-11-10 00:46:50
Subject: Re: pgsql/src/backend/access/transam (xact.c)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group