| 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
| 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 |