Extension of Thick Indexes

From: shrish purohit <shrishpurohit(at)gmail(dot)com>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Extension of Thick Indexes
Date: 2009-04-04 07:36:10
Message-ID: 69b219810904040036o5a36a773u67c87e7e4dd94c6e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

HI All,

I had gone through advantages of visibilitymap along with discussion on
thick index. I have a question.
when we have information about visibility of the data, does it make sense to
propagate values of expression stored in index through various slots of
execution tree?
It would be helpful when index is created on immutable function or
expression.

I am adding additional columns in the heap tuple returned by index with the
expression values stored in the index. For index_only_scan while projecting
the values we will treat expression as normal column. It is simple for
queries with single table. But, when we have joins, we will need to modify
plan to treat expression as normal column. This will involve modifying plan,
intermediate slots. Modification in the plan need to be performed after
finalizing plan, as we will be able to identify whether we can treat the
expression as value only then.

Can there be any other alternative?

Thanks,
Shrish

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2009-04-04 10:03:46 Re: GetCurrentVirtualXIDs()
Previous Message Heikki Linnakangas 2009-04-04 06:59:40 Re: Documentation Update: Document pg_start_backup checkpoint behavior