Re: Optimizing a VIEW - Mailing list pgsql-performance

From Rodrigo E. De León Plicet
Subject Re: Optimizing a VIEW
Date
Msg-id a55915760808161836k3f7e9d46ga8e5e99cf444a05f@mail.gmail.com
Whole thread Raw
In response to Optimizing a VIEW  (Madison Kelly <linux@alteeve.com>)
Responses Re: Optimizing a VIEW
List pgsql-performance
On Fri, Aug 15, 2008 at 1:36 PM, Madison Kelly <linux@alteeve.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

pgsql-performance by date:

Previous
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: Optimizing a VIEW
Next
From: "Gurjeet Singh"
Date:
Subject: Re: Optimizing a VIEW