Hacker News Reader

I was kind of shocked how good PostgesSQL did.

I still think PostgresSQL and MariaDB are a better tool for most jobs considered big data.

Postgres was actually somewhat crippled in these tests since they used json rather than jsonb for storage, which stores the json in a binary format which doesn't need to be serialised on reads.

That's not quite correct. The jsonb requires that reads deserialize jsonb into textual JSON, whereas the json type can be sent directly to the client with no processing.

jsonb is superior when:

1. You want to use any of the built-in JSON functions, e.g. for extracting fields from the document.

2. You want to index the JSON (either the entire thing via GIN, or individual fields via ordinary B-tree indexes).

3. You want to save space; jsonb strips whitespace.

jsonb incurs an overhead on both reads and writes since it must serialize to/from textual JSON.

This is not a cluster test. NoSQL databases in general are optimized for scaling horizontally on commodity hardware. That's more tricky in RDBMS.

Most people I have spoken to are using NoSQL on single nodes.

I think a lot of people jump on NoSQL solutions when scale out isn't needed because of the permeating "do everything in the application / client" mentality these days.

Reply on news.ycombinator.com