DEV Community

PG + JSONB != MongoDB Series' Articles

Back to Franck Pachot's Series
Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database
Cover image for Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database

Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database

10
Comments
2 min read
No Index Only Scan on JSONB Fields (even on scalar)

No Index Only Scan on JSONB Fields (even on scalar)

12
Comments 1
4 min read
No Index for LIKE on JSONB with Array in the Path (GIN limitation)

No Index for LIKE on JSONB with Array in the Path (GIN limitation)

3
Comments
5 min read
No HOT updates on JSONB (write amplification) performance impact

No HOT updates on JSONB (write amplification) performance impact

8
Comments 2
7 min read
JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database

JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database

7
Comments 1
5 min read
Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing!
Cover image for Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing!

Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing!

2
Comments
8 min read
Embedding Into JSONB Still Feels Like a JOIN for Large Documents
Cover image for Embedding Into JSONB Still Feels Like a JOIN for Large Documents

Embedding Into JSONB Still Feels Like a JOIN for Large Documents

4
Comments
21 min read