Re: column limit - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: column limit
Date
Msg-id 20070125175141.GB7220@wolff.to
Whole thread Raw
In response to column limit  ("Isaac Ben" <ib.zero@gmail.com>)
List pgsql-general
On Thu, Jan 25, 2007 at 08:34:08 -0700,
  Isaac Ben <ib.zero@gmail.com> wrote:
> Hi,
> I'm trying to create a table with 20,000 columns of type int2, but I
> keep getting the error message that the limit is 1600.  According to
> this message http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php
> it can be increased, but only up to about 6400.  Can anyone tell me
> how to get 20,000 columns?

Can you explain what you are really trying to do? It is unlikely that using
20000 columns is the best way to solve your problem. If we know what you are
really trying to do we may be able to make some other suggestions.
One thing you might start looking at is using an array or arrays.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats collector frozen?
Next
From: Douglas McNaught
Date:
Subject: Re: sequence increment jumps?