Nikita Glukhov recently identified and fixed a bug in jsquery (https://github.com/postgrespro/jsquery). Indexing of scalars was broken, please upgrade jsquery !

The bug could be demonstrated in this example (query returns different results for seqscan and when using index):

( Read more... )

EDB recently blogged new results from benchmarking PostgreSQL 9.4 and Mongodb
The newest round of performance comparisons of PostgreSQL and MongoDB produced a near repeat of the results from the first tests that proved PostgreSQL can outperform MongoDB. The advances Postgres has made with JSON and JSONB have transformed Postgres’ ability to support ( Read more... )