RE: [HACKERS] TODO list updated

Hiroshi Inoue <inoue@tpf.co.jp>

From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
To: "Tom Lane" <tgl@sss.pgh.pa.us>, "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: "PostgreSQL-development" <pgsql-hackers@postgreSQL.org>
Date: 2000-01-13T03:14:54Z
Lists: 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.
 
> * -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.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp