Home > mailing lists

Re: Best practices for aggregate table design - Mailing list pgsql-general

From	Vick Khera
Subject	Re: Best practices for aggregate table design
Date	October 8, 2015 15:12:26
Msg-id	CALd+dcebJeiXvePvOM3OBj0ZXD2x7tCV-zKF=rkK3=o09bVdSg@mail.gmail.com Whole thread Raw
In response to	Re: Best practices for aggregate table design (hari.fuchs@gmail.com)
List	pgsql-general

Tree view

On Thu, Oct 8, 2015 at 3:49 AM, <hari.fuchs@gmail.com> wrote:

Is there an advantage of hstore vs. json/jsonb?

Definitely over json because that is not indexable. I'm not seeing an advantage over jsonb unless you want to prevent storing complex data structures.

pgsql-general by date:

From: Oleksii Kliukin
Date: 08 October 2015, 11:58:36
Subject: Re: dubious optimization of the function in SELECT INTO target list

From: "Daniel Verite"
Date: 08 October 2015, 15:35:21
Subject: Re: Issues with german locale on CentOS 5,6,7

Re: Best practices for aggregate table design - Mailing list pgsql-general

Previous

Next