On Fri, Aug 15, 2008 at 1:36 PM, Madison Kelly <[EMAIL PROTECTED]> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance