Home > mailing lists

Re: data model one large and many small columns - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: data model one large and many small columns
Date	July 27, 2016 00:17:44
Msg-id	CAKFQuwZmyNjEkVgno=GzA6S9vo-skrqtk5FfJ==o-YOE++tkNg@mail.gmail.com Whole thread Raw
In response to	data model one large and many small columns ("Campbell, Lance" <lance@illinois.edu>)
List	pgsql-admin

On Tue, Jul 26, 2016 at 4:22 PM, Campbell, Lance <lance@illinois.edu> wrote:

Is there any performance to be gained from PostgreSQL by storing the data as two tables versus one table?

PostgreSQL already does this for you via the TOAST mechanism you mentioned.

David J.

From: Scott Whitney
Date: 27 July 2016, 00:00:44
Subject: Re: data model one large and many small columns

From: Tom Lane
Date: 27 July 2016, 00:18:17
Subject: Re: data model one large and many small columns