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
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 |