Re: extend column limit with blocksize does not work - Mailing list pgsql-admin

Yannick Monclin <yannick.monclin@univ-reims.fr> writes:
> I use the query survey software "Limesurvey", when this sofware build
> some complex survey, it's necessary to have more than 1600 columns in
> one table.

I'd suggest rethinking the database schema.  Even if you could get that
to work, it's likely to perform pretty horridly.

> So, i have used this parameter (configure
> --with-blocksize=32) to build my last postgresql  (9.1.2).

BLCKSZ is not the limiting factor here --- it's the tuple header format,
specifically the width of t_hoff.  You might care to look at the first
few comments in src/include/access/htup.h.

            regards, tom lane