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

From Hiroshi Inoue
Subject RE: [HACKERS] TODO list updated
Date
Msg-id 000401bf5d74$5d071d00$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: [HACKERS] TODO list updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] TODO list updated
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.
> * -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 



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] TODO list updated
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] TODO list updated