Re: tables with lots of columns - what alternative from performance point of view?

From: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: tables with lots of columns - what alternative from performance point of view?
Date: 2005-12-08 08:20:09
Message-ID: 9e4684ce0512080020p5ba5775as9a21b6966d505d61@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/7/05, Oleg Bartunov <oleg(at)sai(dot)msu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2005-12-08 08:50:28 Re: TSearch2 / Get all unique lexems
Previous Message Jim C. Nasby 2005-12-08 07:13:15 Re: [GENERAL] 8.1, OID's and plpgsql