Postgres settings
I noticed some of neon's default postgres settings are...abnormal (esepcially compared to vanilla posrgres). Should I completely refrain from touching those?
4 Replies
genetic-orange•3mo ago
Which settings are you looking at in particular?
eastern-cyan•3mo ago
effective_cache_size for example is a whopping 26GB! Meanwhile work_mem is at 4MB, and and maintenance_work_mem is a pretty low 67MB.genetic-orange•3mo ago
This covers some of the values. https://neon.com/docs/reference/compatibility#parameter-settings-that-differ-by-compute-size -
effective_cache_size corresponds to our local file cache optimisation which reduces the latency of our separated storage architecture.
maintenence_work_mem scales automatically with your minimum CU setting
Not sure about work_mem just yet
You are allowed to change them but if you're in that position we usually recommend reaching out to our support team in the console and one of our customer success engineers can figure out the right settings for your load.Neon
Postgres compatibility - Neon Docs
Neon is Postgres. However, as a managed Postgres service, there are some differences you should be aware of. Postgres versions. Neon supports Postgres 14, 15, 16, 17. You can select the Postgres versi...
eastern-cyan•3mo ago
Thanks, I'll have a read on those.