| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: column limit |
| Date: | 2007-01-25 15:48:04 |
| Message-ID: | 45B8D134.5030406@cox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 01/25/07 09:34, Isaac Ben 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?
Why the heck do you need 20 *thousand* columns?
Assuming, though, that you know what you're doing, and the design
isn't horribly botched, then arrays might be what you want.
Normalizing the table might be better, and vertically partitioning
it would be a big performance win if you don't need all 20
*thousand* columns at the same time.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFuNE0S9HxQb37XmcRAoxxAKCLrX0WaekNH8N8ghAzMkhgMmZ43ACg7F0K
0pqcprs/suZ/1xmK73PAdOE=
=WLdL
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | btober | 2007-01-25 15:54:12 | Re: SQL Newbie Question |
| Previous Message | Thorsten Körner | 2007-01-25 15:45:23 | Problem with result ordering |