Re: index on array? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: index on array?
Date
Msg-id 20071102133048.GB9936@svana.org
Whole thread Raw
In response to index on array?  ("none none" <g.jedenastik@gmail.com>)
List pgsql-general
On Fri, Nov 02, 2007 at 01:36:51PM +0100, none none wrote:
> hi@ll
>
> currently i try to implement a data structure for tracking my websites
> traffic
> i'm using a key/value table which contains e.g. http header and/or GET/POST
> data
> a request table (1 request per row) references to the key/value pairs using
> an bigint[] array

In contrib there is the hstore module (for key/value lists) and
intarray module for indexing arrays of integers. Either of these may
help.

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: Re: select random order by random
Next
From: "Gauthier, Dave"
Date:
Subject: Re: young guy wanting (Postgres DBA) ammo