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
franckpachot profile

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

#postgres #mongodb #json #document
10
Comments
2 min read
No Index Only Scan on JSONB Fields (even on scalar)
franckpachot profile

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

#postgres #mongodb #json #document
12
Comments 1
4 min read
No Index for LIKE on JSONB with Array in the Path (GIN limitation)
franckpachot profile

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

#mongodb #postgres #database #index
3
Comments
5 min read
No HOT updates on JSONB (write amplification) performance impact
franckpachot profile

No HOT updates on JSONB (write amplification) performance impact

#postgres #document #database #mongodb
8
Comments 2
7 min read
JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database
franckpachot profile

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

#postgres #jsonb #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!
franckpachot profile

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

#postgres #json #jsonb #mongodb
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
franckpachot profile

Embedding Into JSONB Still Feels Like a JOIN for Large Documents

#postgres #mongodb #json #database
4
Comments
21 min read
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
Cover image for JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
franckpachot profile

JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols

#mongodb #postgres #json #network
7
Comments 2
13 min read