Tuning Postgres Configurations

panic: pq: sorry, too many clients already
$ psql -U postgres -c 'SHOW config_file'

Let’s get started

max_connections

shared_buffers

effective_cache_size

Source: https://www.cybertec-postgresql.com/

maintenance_work_mem

wal_buffers

effective_io_concurrency

Source: https://portavita.github.io/

seq_page_cost

random_page_cost

work_mem

Source: https://severalnines.com/

References

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store