Re: Beyond the 1600 columns limit on windows

On 8 Nov 2005, at 16:06, Scott Marlowe wrote:

> On Tue, 2005-11-08 at 09:45, Tino Wildenhain wrote:
>
>> Alex Stapleton schrieb:
>>
>>>
>>> On 8 Nov 2005, at 12:50, Tino Wildenhain wrote:
>>>
>>>
>>>> Evandro's mailing lists (Please, don't send personal messages  
>>>> to  this
>>>> address) schrieb:
>>>>
>>>>
>>>>> Hi guys,
>>>>>  I would like to know if it is possible to have more than 1600
>>>>> columns on windows without recompiling postgres.
>>>>>
>>>>>
>>>>>
>>>> I would like to know who on earth needs 1600 columns and even  
>>>> beyond?
>>>> Hint: you can have practically unlimited rows in your n:m table :-)
>>>>
>>>>
>>>
>>> Well this screams random arbitrary limit to me. Why does this limit
>>> exist? What ever happened to the holy 0,1,infinity triumvirate?
>>>
>>
>> I guess it eases implementation and there is no reason to go so high
>> on columns either. The limit could even be lower w/o and hurts but
>> 1600 seems skyrocket high enough (read unlimited :-)
>>
>
> I'd have to vote with Tino here.  Why worry about an arbitrary  
> limit you
> should never really be approaching anyway.  If a table has more than
> several dozen columns, you've likely missed some important step of
> normalization.  Once you near 100 columns, something is usually  
> horribly
> wrong.  I cannot imagine having a table that actually needed 1600 or
> more columns.
>
> And, Evandro, nothing is free.  If someone went to the trouble of
> removing the limit of 1600, we'd probably pay in some other way, most
> likely with poor performance.  There are other, far more important
> features to work on, I'd think.
>

Oh wait, PG is written in C isn't it. I guess fixed size things are a  
bit easier to deal with. Pardon me then :)