Re: Extension of Thick Indexes

Hi All,

We are extending Gokul's Thick index functionality.
I am attaching design doc and patch here with it.

Thick index improvements
1. Fix existing defects
2. Extend thick index usage for group by, count, nested queries, and
"delete/update with join" queries.
3. Improve cost estimates

Pending Features
1. Expression based thick index.
2. Support for Or conditions.
3. Optimization for update/delete queries.

Details can be found in design doc. We are using anoncvs checkout dated 1
dec 08. Please take a look at it.

Thanks,
Shrish Purohit | Software Engineer | Persistent Systems
shrish_purohit(at)persistent(dot)co(dot)in | Cell: +91 98509 59940 | Tel: +91 (20)
3023 4493
Innovation in software product design, development and delivery-
www.persistentsys.com

-----Original Message-----
From: Amit Gupta [mailto:amit(dot)pc(dot)gupta(at)gmail(dot)com]
Sent: Friday, February 06, 2009 3:47 PM
To: pgsql-hackers(at)postgresql(dot)org
Cc: gokul007(at)gmail(dot)com
Subject: Re: Extension of Thick Indexes

We are plainning to use the attached result for estimating cost of
scanning thick indexes.

Regards,
Amit
Persistent Systems
www.persistentsys.com

On 1/22/09, Amit Gupta <amit(dot)pc(dot)gupta(at)gmail(dot)com> wrote:
> Hi,
>
> We are extending Gokul's Thick index functionality
> (http://archives.postgresql.org/pgsql-patches/2008-01/msg00092.php)
> on 8.4 code base to
> - fix existing defects
> - Extend thick index usage for group by, count, nested queries, and
> "delete/update with join" queries.
> - Improve cost estimates for using thick indexes, and
> - Support OR condition queries using thick indexes (which involves
> computation of bitmap-or)
>
> Details of the above features can be seen at
> http://aurora.regenstrief.org/postgresql/report/6
>
> Please let me know if you have any comments or suggestions.
>
> Thanks,
> Amit
> Persistent Systems
>
>

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.