Re: Optimizing a VIEW

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: "Madison Kelly" <linux(at)alteeve(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimizing a VIEW
Date: 2008-08-17 01:36:21
Message-ID: a55915760808161836k3f7e9d46ga8e5e99cf444a05f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Aug 15, 2008 at 1:36 PM, Madison Kelly <linux(at)alteeve(dot)com> wrote:
> The 'cust_id' references the customer that the given data belongs to. The
> reason for this "data bucket" (does this structure have a proper name?) is
> that the data I need to store on a give customer is quite variable and
> outside of my control. As it is, there is about 400 different variable/value
> pairs I need to store per customer.

For you very specific case, I recommend you check out contrib/hstore:
http://www.postgresql.org/docs/current/static/hstore.html

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gurjeet Singh 2008-08-17 02:19:28 Re: Optimizing a VIEW
Previous Message Rodrigo E. De León Plicet 2008-08-17 01:33:06 Re: Optimizing a VIEW