Page 1 of 1

postgresql.conf parameters

PostPosted: Fri Feb 17, 2017 3:39 pm
by huber
I startet using Postgres again and found some difference in the postgresql.conf parameters compared to earlier versions.

The following postgresql.conf parameters don't seem to exist in version 9.6 any more (and maybe in earlier versions as well)
max_fsm_pages
fsync

Are they replaced by some other parameters?

maintenance_work_me = 2GB used to be the max. Is Postgres still not using more?

Does anyone use in a production environment
random_page_cost = 20
checkpoint_segements = 128
checkpoint_completion_target = 0.9
default_statistics_target = 500
wal_buffers =

What numbers are you developers using?

I am also interested in experiences using SSDs for the database, indexes, ...

Thanks for sharing the info.

Regards,