Postgres Pro
Downloads
Home   >   mailing lists

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

From Dmitriy Igrishin
Subject Re: More then 1600 columns?
Date
Msg-id AANLkTinb-Zph2g9pEcaoOsJUKMh17h=2AQmWZpC4cTYs@mail.gmail.com
Whole thread Raw
In response to Re: More then 1600 columns?  (John R Pierce <pierce@hogranch.com>)
Responses Re: More then 1600 columns?  ("Mark Mitchell" <mmitchell@riccagroup.com>)
List pgsql-general
Tree view
Sounds like semi-structured data handling. For this tasks hstore would be ideal, IMO.

2010/11/12 John R Pierce <pierce@hogranch.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
// Dmitriy.


pgsql-general by date:

Previous
From: Peter Bex
Date:
Subject: Re: More then 1600 columns?
Next
From: Vangelis Katsikaros
Date:
Subject: Re: ignore errors for COPY [solved]