postgresql.conf parameters

Questions and answers regarding general SQL and backend databases

postgresql.conf parameters

Postby huber » Fri Feb 17, 2017 3:39 pm

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,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 516
Joined: Mon May 14, 2012 11:31 pm

Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 5 guests

cron