Re: More then 1600 columns? - Mailing list pgsql-general

From Peter Bex
Subject Re: More then 1600 columns?
Date
Msg-id 20101112092511.GA19972@frohike.homeunix.org
Whole thread Raw
In response to Re: More then 1600 columns?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
On Fri, Nov 12, 2010 at 10:18:31AM +0100, Thomas Kellerer wrote:
> The hstore module would also be a viable alternative - and it's indexable
> as well.

That's what the post I replied to mentioned :)

Also, when I looked at hstore, it had a limitation on its length which
made it a little dangerous to use for me:
"In the current implementation, neither the key nor the value string
 can exceed 65535 bytes in length"
[http://www.postgresql.org/docs/8.4/interactive/hstore.html]

It looks like this limitation has been lifted in 9.0.  Good news!

Cheers,
Peter
--
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
 is especially attractive, not only because it can be economically
 and scientifically rewarding, but also because it can be an aesthetic
 experience much like composing poetry or music."
                            -- Donald Knuth

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: More then 1600 columns?
Next
From: Dmitriy Igrishin
Date:
Subject: Re: More then 1600 columns?