Re: data model one large and many small columns

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: data model one large and many small columns
Date: 2016-07-26 21:17:36
Message-ID: CAKFQuwZmyNjEkVgno=GzA6S9vo-skrqtk5FfJ==o-YOE++tkNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jul 26, 2016 at 4:22 PM, Campbell, Lance <lance(at)illinois(dot)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.

https://www.postgresql.org/docs/9.6/static/storage-toast.html

David J.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2016-07-26 21:18:08 Re: data model one large and many small columns
Previous Message Scott Whitney 2016-07-26 21:00:35 Re: data model one large and many small columns