Postgres Pro
Downloads
Home   >   mailing lists

Re: tables with lots of columns - what alternative from performance point of view? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: tables with lots of columns - what alternative from performance point of view?
Date
Msg-id 9e4684ce0512080020p5ba5775as9a21b6966d505d61@mail.gmail.com
Whole thread Raw
In response to Re: tables with lots of columns - what alternative from  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view
On 12/7/05, Oleg Bartunov <oleg@sai.msu.su> wrote:
contrib/hstore will save you.
See http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstore
for details.

thanks. i didn't know about it, and it looks great. but i'm not sure if we will be able to use it - my developers use java + hibernate, and they say it cannot work with any "fancy" datatypes (including such a base things like "INTERVAL").
i will definitelly use is though in my other (not hibernate-dependant) projects.

best regards

depesz

pgsql-general by date:

Previous
From: a.j.langereis@inter.nl.net (A.j. Langereis)
Date:
Subject: Re: Letting a function return multiple columns instead of a single complex one
Next
From: Hannes Dorbath
Date:
Subject: Re: TSearch2 / Get all unique lexems