Re: how to add more than 1600 columns in a table?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: pabloa98 <pabloa98(at)gmail(dot)com>
Cc: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, Joe Conway <mail(at)joeconway(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: how to add more than 1600 columns in a table?
Date: 2019-04-24 23:01:15
Message-ID: 20190424230115.GA8863@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2019-Apr-24, Alvaro Herrera wrote:

> Note that with pg12 you could have your own table AM that supported
> wider ItemIds as a (small?) change on heapam, rather than supplant it
> for all tables. That way you would only pay the (probably considerable)
> cost of the wider line pointers on all tables ...

"That way you would only pay the (probably considerable) cost of the
wider line pointers on the tables that need it rather than all of them."

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-04-24 23:02:02 Re: how to add more than 1600 columns in a table?
Previous Message Alvaro Herrera 2019-04-24 22:55:19 Re: how to add more than 1600 columns in a table?