Re: [HACKERS] TODO list updated - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] TODO list updated
Date
Msg-id 200001130334.WAA29279@candle.pha.pa.us
Whole thread Raw
In response to RE: [HACKERS] TODO list updated  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
> > -----Original Message-----
> > From: owner-pgsql-hackers@postgreSQL.org
> > [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Tom Lane
> > 
> > TODO item comments:
> > 
> > * Pull requested data directly from indexes, bypassing heap data
> > 
> > I doubt this is ever going to happen --- to make it possible, we'd
> > have to store tuple-commit status in index entries as well as in the
> > tuples themselves.  That would be a substantial space and speed penalty;
> > is the potential gain really worth it?
> >
> 
> I agree with Tom.  We could omit rows using indexes but cound't
> pull data from indexes without time qualification of heap tuples now.

Removed.

>   
> > * -elog() flushes cache, try invalidating just entries from current xact,
> >   perhaps using invalidation cache
> > 
> > I don't think this is done?
> >
> 
> If I recognize correctly this item,this was fixed by my recent changes
> for cache invalidation though I had changed it without knowing this item.

Great.  I thought so.  I remember some CVS messages saying this.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] TODO list updated
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] libpq+MB/putenv(), getenv() clean up