Re: More then 1600 columns?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: More then 1600 columns?
Date: 2010-11-12 09:18:31
Message-ID: ibj0p7$lmr$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Bex, 12.11.2010 08:36:
> What can also work extremely well is storing the data in an array.
> If you need to access the array based on more meaningful keys you could
> store key/index pairs in another table.
>

The hstore module would also be a viable alternative - and it's indexable as well.

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Bex 2010-11-12 09:25:11 Re: More then 1600 columns?
Previous Message John R Pierce 2010-11-12 08:57:32 Re: More then 1600 columns?