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

Re: arrays and indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>,Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: arrays and indexes
Date: 2004-07-26 21:21:12
Message-ID: 9847.1090876872@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Greg Stark <gsstark(at)mit(dot)edu> writes:
> I would be curious to know how it goes. My own project uses
> denormalized sets stored as arrays as well, though in my case they're
> precalculated from the fully normalized data. I tried to use GiST
> indexes but ran into problems combining the btree-GiST code with array
> GiST code in a multicolumn index. I still don't really know why it
> failed, but after two days building the index I gave up.

Sounds like a bug to me.  Could you put together a test case?

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Litao WuDate: 2004-07-26 21:26:36
Subject: Re: Timestamp-based indexing
Previous:From: Greg StarkDate: 2004-07-26 20:40:32
Subject: Re: arrays and indexes

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