| 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: | Whole Thread | Raw Message | 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 |