From: | Michael H <michael(at)wemoto(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |
Date: | 2015-08-18 15:20:34 |
Message-ID: | 55D34D42.1070307@wemoto.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2015-08-18 15:49:24 | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |
Previous Message | Joshua D. Drake | 2015-08-18 15:12:09 | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |