Here are the only things that I amended, all other settings are defaults.
maintenance_work_mem=2GB
checkpoint_segments=64
wal_keep_segments=128
max_prepared_transactions=10
max_wal_senders=3
wal_level=hot_standby
max_files_per_process=1000000
max_stack_depth=7MB
wal_buffers=64MB
shared_buffers=60GB
work_mem64MB
Other settings were changed and reverted again due to performance decreases.
I also dropped shared_buffers down to 32GB, TPS dropped further.
On 18/08/15 16:12, Joshua D. Drake wrote:
>
> On 08/18/2015 08:01 AM, Michael H wrote:
>>
>> Hi,
>>
>> I've been tuning our new database server, here's some info...
>>
>> CentOS Linux release 7.1.1503 (Core)
>> 3.10.0-229.11.1.el7.x86_64
>>
>> 8 x 16GB 1600MHz PC3-12800 DDR3 - 128GB total
>> 2 x AMD Opteron 6386SE 2.8GHz/16-core/140w - 32 cores total
>> 4 x 300GB SAS 10k HDD - raid 1+0 configuration
>> 1GB FBWC for P-series smart array - cache enabled
>>
>
>> I praised 9.4 for the new features and now I'm cursing it!
>>
>> any info would be appreciated,
>
> Without the respective postgresql.conf files, none of this means anything.
>
> Sincerely,
>
> JD
>
>