Re: index on array?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: none none <g(dot)jedenastik(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index on array?
Date: 2007-11-02 13:30:49
Message-ID: 20071102133048.GB9936@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 02, 2007 at 01:36:51PM +0100, none none wrote:
> hi(at)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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sascha Bohnenkamp 2007-11-02 13:49:57 Re: Copy the database..
Previous Message Gauthier, Dave 2007-11-02 13:28:41 Re: young guy wanting (Postgres DBA) ammo