Re: Optimizing a VIEW

Поиск
Список
Период
Сортировка
От Rodrigo E. De León Plicet
Тема Re: Optimizing a VIEW
Дата
Msg-id a55915760808161836k3f7e9d46ga8e5e99cf444a05f@mail.gmail.com
обсуждение исходный текст
Ответ на Optimizing a VIEW  (Madison Kelly <linux@alteeve.com>)
Ответы Re: Optimizing a VIEW
Список 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 по дате отправления:

Предыдущее
От: "Rodrigo E. De León Plicet"
Дата:
Сообщение: Re: Optimizing a VIEW
Следующее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: Optimizing a VIEW