Re: extend column limit with blocksize does not work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yannick Monclin <yannick.monclin@xxxxxxxxxxxxx> 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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux