Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Including Snapshot Info with Indexes

From: "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
To: "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org>, pgsql-patches(at)postgresql(dot)org, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Subject: Re: [HACKERS] Including Snapshot Info with Indexes
Date: 2008-01-28 13:21:57
Message-ID: 9362e74e0801280521j7d60c983kc05ef9847686a103@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
I am not seeing my mail getting listed in the archives. So i am just
resending it, in case the above one has got missed.

Thanks,
Gokul.

On Jan 28, 2008 4:14 PM, Gokulakannan Somasundaram <gokul007(at)gmail(dot)com>
wrote:

>
> Doh!  Can you please send another patch with gram.y as well.  Mine is
> > missing all of the thick index stuff.
> >
>
> I apologize for the mistake. I am sending the revised patch - generated
> against CVS Head. Thanks for the guidance provided.
>
> This patch also fixes a bug, which appeared in select count(1) from table
> where varchar_column like 'xx%' kind of queries.
>
> In order to find out whether the index will be able to answer all the
> where clause conditions, i have put the checks under
> expand_indexqual_conditions function. Please get back, if there is any
> problem with the approach.
>
> Waiting for feedback...
>
> Thanks,
> Gokul.
>
>

Attachment: thickindex.patch.gz
Description: application/x-gzip (34.5 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2008-01-28 13:25:10
Subject: Re: GSSAPI doesn't play nice with non-canonical host names
Previous:From: Zdenek KotalaDate: 2008-01-28 12:16:12
Subject: Re: Proposal: Integrity check

pgsql-patches by date

Next:From: Jonah H. HarrisDate: 2008-01-28 13:51:30
Subject: Re: [PATCHES] Including Snapshot Info with Indexes
Previous:From: Pavel StehuleDate: 2008-01-28 12:51:31
Subject: WIP: plpgsql source code obfuscation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group