Lesson 5.1 — PostgreSQL Memory Model (Explained)

Click on the "Edit" button in the top corner of the screen to edit your slide content.

Why defaults fail

  • AI queries are read-heavy
  • Vector similarity is memory intensive

Recommended Settings

shared_buffers = 4GB

effective_cache_size = 12GB

work_mem = 64MB

maintenance_work_mem = 512MB

Danger Zone

Too high work_mem × many workers = OOM (out of memory) crash

Rating
0 0

There are no comments for now.

to be the first to leave a comment.