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

Re: More then 1600 columns?

From: Peter Bex <Peter(dot)Bex(at)xs4all(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: More then 1600 columns?
Date: 2010-11-12 07:48:57
Message-ID: 20101112074857.GB16653@frohike.homeunix.org (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Nov 12, 2010 at 10:43:14AM +0300, Dmitriy Igrishin wrote:
> Hey Peter,
> 
> Unfortunately, there is no indexes on arrays (only on expressions).
> With hstore we can easily create GiST index for effective access.

True. In my project I only ever needed to search on a particular key,
and I made sure that that key always had a fixed position in the array.
You can then create an index on the expression that extracts that
index from the array.

Cheers,
Peter
-- 
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
 is especially attractive, not only because it can be economically
 and scientifically rewarding, but also because it can be an aesthetic
 experience much like composing poetry or music."
							-- Donald Knuth

In response to

pgsql-general by date

Next:From: Pavel StehuleDate: 2010-11-12 07:59:58
Subject: Re: More then 1600 columns?
Previous:From: Dmitriy IgrishinDate: 2010-11-12 07:43:14
Subject: Re: More then 1600 columns?

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