Skip to content

Instantly share code, notes, and snippets.

@zekefast
Last active December 31, 2022 19:04
Show Gist options
  • Star 8 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zekefast/42273658939724ba7c7a to your computer and use it in GitHub Desktop.
Save zekefast/42273658939724ba7c7a to your computer and use it in GitHub Desktop.
PostgreSQL configuration tuning to improve tests performance of database interactions.
# PostgreSQL configuration tuning to improve tests performance of database interactions.
# Look for more detailed description in follow articles:
# - http://rhaas.blogspot.com/2010/06/postgresql-as-in-memory-only-database_24.html
#
# ATTENTION:
# Before appling those settings ensure that you have no important data in your cluster, because those settings
# could cause problems on your production database in case of appliance.
#
# Ensure follow settings have given values.
# See more detailed description for the option in Postgres documentation at
# http://www.postgresql.org/docs/9.1/static/runtime-config-wal.html in "18.5. Write Ahead Log" section.
fsync=off
synchronous_commit=off
full_page_writes=off
# See more detailed description for the option in Postgres documentation at
# http://www.postgresql.org/docs/9.1/static/runtime-config-resource.html in "18.4.4. Background Writer" section.
bgwriter_lru_maxpages=0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment