Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Peter BexDate: 2010-11-12 09:25:11
Subject: Re: More then 1600 columns?
Previous:From: John R PierceDate: 2010-11-12 08:57:32
Subject: Re: More then 1600 columns?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group