Indexing for Expression type data using GIST

On Thu, Mar 27, 2008 at 02:03:09PM -0500, Wizard Shah wrote:

Hi All,

I am trying to implement indexing mechanism for the Expression type
data using GIST. For that purpose I need to store some extra
information in the Meta-Data of the GIST Index.

There is no real provision for this but, depending on what it is there
may be other options. For example perhaps you can use the typmod or
something like that.

The information is entered when the index is created on the table.
Can any body give me some suggestion how to do that. I'll be really
grateful.

If you provide some more information about what the information
represents we might be able to give you a better idea.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Hi,

The information is a simple structure with a string and integer. It basically represents what attributes of the expression are going to be part of the index

struct ExpIndexInfo
{
int count;
char* ExpIndex;
};

e.g we have an expression data like "price > 1300 AND color = blue AND mileage > 20000" and the index will include only the price and mileage attributes. The string "ExpIndex" will contain the attributes to be indexed (price and mileage) and integer "count" maintains the max number of attributes to be indexed on the expression. This is all to be specified at the index creation time and stored in the Meta-Data to be changed or retrieved later

Regards

Salman

Date: Thu, 27 Mar 2008 20:34:04 +0100
From: kleptog@svana.org
To: wizardshah@hotmail.com
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Indexing for Expression type data using GIST

On Thu, Mar 27, 2008 at 02:03:09PM -0500, Wizard Shah wrote:

Hi All,

I am trying to implement indexing mechanism for the Expression type
data using GIST. For that purpose I need to store some extra
information in the Meta-Data of the GIST Index.

There is no real provision for this but, depending on what it is there
may be other options. For example perhaps you can use the typmod or
something like that.

The information is entered when the index is created on the table.
Can any body give me some suggestion how to do that. I'll be really
grateful.

If you provide some more information about what the information
represents we might be able to give you a better idea.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines.

_________________________________________________________________
How well do you know your celebrity gossip?
http://originals.msn.com/thebigdebate?ocid=T002MSN03N0707A