| From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
|---|---|
| To: | Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com> |
| Cc: | "Madison Kelly" <linux(at)alteeve(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimizing a VIEW |
| Date: | 2008-08-17 02:19:28 |
| Message-ID: | 65937bea0808161919t4b0f19a0md90eae487b86429@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sun, Aug 17, 2008 at 7:06 AM, Rodrigo E. De León Plicet <
rdeleonp(at)gmail(dot)com> wrote:
> 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
>
>
Awesome!!!! Any comments on the performance of hstore?
Best regards,
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-08-17 10:55:36 | Re: Filesystem benchmarking for pg 8.3.3 server |
| Previous Message | Rodrigo E. De León Plicet | 2008-08-17 01:36:21 | Re: Optimizing a VIEW |