shared_buffers = 1GB temp_buffers = 256MB work_mem = 256MB maintenance_work_mem = 1GB effective_io_concurrency = 0 wal_buffers = 1MB checkpoint_segments = 2048 random_page_cost = 6.0 effective_cache_size = 2GB synchronous_commit = on #commit_delay = 1000 #wal_writer_delay = 100 #default_statistics_target = 1000 bgwriter_lru_maxpages = 1000 log_destination = 'stderr' logging_collector = on #log_checkpoints = on #log_connections = on #log_disconnections = on #log_lock_waits = on #log_statement = 'none' #log_statement_stats=1 #log_planner_stats=1 #log_parser_stats=1 #log_executor_stats=1