News for hackers. Stuff that matters.

A comment on PostgreSQL 9.4 Beta 1 Released. Parent comment

Re:PostgreSQL 9.4 Beta 1 Released by meritt on Thursday May 15, 2014 @01:22PM (#7750849)
Or alternately: Why wasn't the JSON parsed into normal form if the intent was to search & filter across that data.
[ Parent | on HN ]
Re:PostgreSQL 9.4 Beta 1 Released by gdulli on Thursday May 15, 2014 @02:36PM (#7751323)
To get the same flexibility you'd want from a nosql data store. Without giving up the simpler, more open access methods. The schema is partly predictable (and indexed or fielded on those parts) and partly unpredictable.
[ Parent | on HN ]
Re:PostgreSQL 9.4 Beta 1 Released by ddorian43 on Thursday May 15, 2014 @05:06PM (#7752237)
why not add the partly predicted keys as columns ?

also jsonb will require a little more storage

is 8tb in 1 tablespace/db ?

[ Parent | on HN ]