News for hackers. Stuff that matters.
Re:Why HStore2/jsonb is the most important patch of PostgreS... by masklinn on Sunday February 23, 2014 @07:04AM (#7285674)
> While I don't mind seeing some non relational additions like JSON, it shouldn't be detrimental to Postgres relational core.

The patchset in question is an improvement of hstore[0] (typed hstore, nested hstore) and unification of json and hstore (by using the binary hstore format for both). There is no more detriment to the relational core than when hstore or XML were originally added. Also, next-GIN[1] by the same people[2], not sure it's part of the patch mentioned.

[0] [PDF warning] http://www.sai.msu.su/~megera/postgres/talks/hstore-dublin-2...

[1] [PDF warning] http://www.sai.msu.su/~megera/postgres/talks/Next%20generati...

[2] Who previously contributed GiST and GIN, FTS, ltree or intarray

Re:Why HStore2/jsonb is the most important patch of PostgreS... by jeltz on Sunday February 23, 2014 @09:26AM (#7285964)
The GIN improvements were submitted as a set of separate patches and several of them have been merged into 9.4.
Re:Why HStore2/jsonb is the most important patch of PostgreS... by masklinn on Sunday February 23, 2014 @11:35AM (#7286407)
Good to know, thanks a lot for the info.
Re:Why HStore2/jsonb is the most important patch of PostgreS... by jeltz on Sunday February 23, 2014 @12:45PM (#7286674)
I know that the GIN compression patch has been committed and some of the patch for speeding up searches by skipping posting list entires, but I have not seen anything about the third part, speeding up FTS by adding ordering info to the indexes.

https://commitfest.postgresql.org/action/patch_view?id=1357 https://commitfest.postgresql.org/action/patch_view?id=1382

Re:Why HStore2/jsonb is the most important patch of PostgreS... by twic on Sunday February 23, 2014 @10:53AM (#7286211)
They've still got a .su address! Old school!