Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint
Date: 2018-11-07 14:48:24
Message-ID: 27417.1541602104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> On 6/11/18 4:58 μ.μ., Tom Lane wrote:
>> I have no idea how that could happen exactly. If it happens again,
>> it'd be really interesting to attach to the checkpointer with a
>> debugger and collect a stack trace.

> Thank you Tom. Should I also re-run configure --enable-debug && make clean install ? Initially PostgreSQL was built without --enable-debug, so currently it does not show source code line numbers in
> gdb bt .

Yeah, if you do not have debug symbols installed, the stack trace
will be of very little use.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Pepe TD Vo 2018-11-07 15:10:25 query can't merge into table of the other schema
Previous Message Pepe TD Vo 2018-11-07 14:12:17 execute a procedure from another procudure?