Re: 1600 column limit per table

Mike Weber <j_weber@tcdi.com> writes:
> I ran into the 1600 column upper bound in a table and I am trying to
> assess if I can work around the limit or if I am in need of a re-design
> of my application.

You need to redesign.  The 1600 limit has some slop (intentionally)
but not a lot of slop --- I think the hard maximum without breaking
compatibility with 8.1's on-disk format would be 1736.

Most people think that rows that wide are a sign of bad SQL design
anyway, which is why there's not been any interest in trying to
raise the limit.  Perhaps you could collapse multiple similar columns
into an array column?

            regards, tom lane