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

Re: More then 1600 columns?

From: "Mark Mitchell" <mmitchell(at)riccagroup(dot)com>
To: "'Dmitriy Igrishin'" <dmitigr(at)gmail(dot)com>,"'John R Pierce'" <pierce(at)hogranch(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: More then 1600 columns?
Date: 2010-11-12 15:49:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
hstore does look like it could work out better then a mother load of columns like we have now so long as the index support is good and there are no limits on value length.
It seems that the limit was lifted in 9.0? Is that true?
I was not aware of hstore when we started using postgres, that’s for the info!
And yes we do data analysis that tortures SQL, but SQL allows us to do so many things quickly and less painfully. Better to torture the machines then torture ourselves…. 
- Mark
From:pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Dmitriy Igrishin
Sent: Friday, November 12, 2010 4:50 AM
To: John R Pierce
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] More then 1600 columns?
Sounds like semi-structured data handling. For this tasks hstore would be ideal, IMO.
2010/11/12 John R Pierce <pierce(at)hogranch(dot)com>
I looked up the OP's domain.    They develop medical research data analysis software.

That sort of software and the kinds of data analysis they do tortures SQL databases.   These 1600+ element rows are likely very sparse.

Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:

// Dmitriy.

In response to

pgsql-general by date

Next:From: Rob SargentDate: 2010-11-12 15:50:55
Subject: Re: More then 1600 columns?
Previous:From: Mark MitchellDate: 2010-11-12 15:38:03
Subject: Re: More then 1600 columns?

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