Re: hstore - Implementation and performance issues around its operators

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: hstore - Implementation and performance issues around its operators
Date: 2011-06-21 10:14:46
Message-ID: BANLkTikLbcU_Wm-532xEke7VzmxhX+BdMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

On Tue, Jun 21, 2011 at 12:04 PM, Stefan Keller <sfkeller(at)gmail(dot)com> wrote:

> 1. Obviously the '@>' has to be used in order to let use the GiST index.
> Why is the '->' operator not supported by GiST ('->' is actually
> mentioned in all examples of the doc.)?
>

I believe it's an architecture problem. You actually need not '->' operator
to be supported by GiST but "column -> 'field_name' = value" expression.
Probably, I'm missing something, but I think supporting of this require
significant catalog changes.

------
With best regards,
Alexander Korotkov.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2011-06-21 11:36:05 Re: Re: [COMMITTERS] pgsql: Fixed string in German translation that causes segfault.
Previous Message Alexander Korotkov 2011-06-21 10:08:25 Re: WIP: Fast GiST index build