[PERFORM] PostgreSQL 9.6 wals management

2017-11-20 Thread Mariel Cherkassky
Hi, I'm trying to understand my wals behavior on my postgresql environment. My wal settings are : wal_keep_segments = 200 max_wal_size = 3GB min_wal_size = 80MB archive_command = 'cp %p /PostgreSQL-wal/9.6/pg_xlog/wal_archives/%f' archive_timeout = 10 #checkpoint_flush_afte

Re: [PERFORM] PostgreSQL 9.6 wals management

2017-11-20 Thread Michael Paquier
On Mon, Nov 20, 2017 at 6:02 PM, Mariel Cherkassky wrote: > This morning , I set the wal_keep_segments to 100 and I set the > archive_timeout to 6 minutes. Now, after setting those settings and starting > the cluster wals switch is working fine and I didnt see that many wals were > However, doesnt

Re: [PERFORM] PostgreSQL 9.6 wals management

2017-11-20 Thread Mariel Cherkassky
Thank you for the clarification. בתאריך 20 בנוב׳ 2017 14:28,‏ "Michael Paquier" כתב: > On Mon, Nov 20, 2017 at 6:02 PM, Mariel Cherkassky > wrote: > > This morning , I set the wal_keep_segments to 100 and I set the > > archive_timeout to 6 minutes. Now, after setting those settings and > starti

[PERFORM] Migration to pglister - Before

2017-11-20 Thread Stephen Frost
Greetings, We will be migrating these lists to pglister in the next few minutes. This final email on the old list system is intended to let you know that future emails will have different headers and you will need to adjust your filters. The changes which we expect to be most significant to user