Re: Extension of Thick Indexes

From: Amit Gupta <amit(dot)pc(dot)gupta(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: gokul007(at)gmail(dot)com
Subject: Re: Extension of Thick Indexes
Date: 2009-02-06 10:17:28
Message-ID: 8d79a95c0902060217v4afb8804gcfb35573455270d7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
>
>

Attachment Content-Type Size
Index_Cost_Expr.pdf application/pdf 58.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2009-02-06 11:58:25 Re: Synch Replication
Previous Message K, Niranjan (NSN - IN/Bangalore) 2009-02-06 09:46:53 Re: Synch Replication