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

On 12/7/05, Oleg Bartunov wrote: contrib/hstore will save you.See http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstorefor 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, a

Re: [GENERAL] tables with lots of columns - what alternative from

contrib/hstore will save you. See http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstore for details. Oleg On Wed, 7 Dec 2005, hubert depesz lubaczewski wrote: hi jus recently there were some thread on postgresql list with people asying : i have 700 columns, i have 1000 column

[GENERAL] tables with lots of columns - what alternative from performance point of view?

hi jus recently there were some thread on postgresql list with people asying : i have 700 columns, i have 1000 columns and so on. some people, imediatelly responded: change your schema. this is what forced to me ask: i have a situation where i ahve to store a number of "objects" in database. all o