Sounds like semi-structured data handling. For this tasks hstore would be ideal, IMO.
2010/11/12 John R Pierce <pie...@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.