0

I am tuning a postgresql.conf file and here is what is shown in PG admin configuration editor

configuration editor

What does the current value corresponds to? For the shared buffers (red line), what is the value there?

  • I think you should do this in the conf file directly. Also, after logging into the DB, a SHOW shared_buffers; will show you the value in use. If the question is what exactly 524288 means (if it is bytes, pages, etc.), please refer to the documentation: postgresql.org/docs/current/static/… - in the end, SELECT unit FROM pg_settings WHERE name = 'shared_buffers'; will show you the default unit. – dezso Jul 26 '18 at 8:37
2

Current value is what the currently active database is using.

many of those settings require the database to be restarted (or reboot) before they take effect.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.