RE: pg_xlog unbounded growth

2018-02-07 Thread Alex Ignatov
Have you tried archive_command='/bin/true' as Andreas wrote? -Original Message- From: Stefan Petrea [mailto:stefan.pet...@tangoe.com] Sent: Wednesday, January 24, 2018 2:48 PM To: pgsql-performa...@postgresql.org Subject: pg_xlog unbounded growth Hello, This email is structured in sec

Re: pg_xlog unbounded growth

2018-01-26 Thread Andreas Kretschmer
Hi, Am 24.01.2018 um 12:48 schrieb Stefan Petrea: We're using PostgreSQL 9.6.6 on a Ubuntu 16.04.3 LTS. During some database imports(using pg_restore), we're noticing fast and unbounded growth of pg_xlog up to the point where the partition(280G in size for us) that stores it fills up and Postgr

Re: pg_xlog unbounded growth

2018-01-25 Thread Tomas Vondra
On 01/24/2018 12:48 PM, Stefan Petrea wrote: > Hello, > > This email is structured in sections as follows: > > 1 - Estimating the size of pg_xlog depending on postgresql.conf parameters > 2 - Cleaning up pg_xlog using a watchdog script > 3 - Mailing list survey of related bugs > 4 - Thoughts >

Re: pg_xlog unbounded growth

2018-01-25 Thread Laurenz Albe
Stefan Petrea wrote: > During some database imports(using pg_restore), we're noticing fast > and unbounded growth of pg_xlog up to the point where the > partition(280G in size for us) that stores it fills up and PostgreSQL > shuts down. What do you see in pg_stat_archiver? Yours, Laurenz Albe