Re: More then 1600 columns?

["Mark Mitchell" <mmitchell@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Dmitriy Igrishin
Sent: Friday, November 12, 2010 4:50 AM
To: John R Pierce
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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@xxxxxxxxxxxx>

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
// Dmitriy.