WAL segments pile up during standalone mode

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: WAL segments pile up during standalone mode
Date: 2011-03-02 18:22:01
Message-ID: 1299085966-sup-8520@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I noticed that in standalone mode, WAL segments don't seem to be
recycled. This could get problematic if you're forced to vacuum large
tables in that mode and space for WAL is short.

I can reproduce in HEAD easily by doing a large bulk insertion in
standalone mode. If I stop the server, start in normal mode and
shutdown (or checkpoint), the extra segments go away as expected.

This was reported in pgsql-es-ayuda yesterday.

--
Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Popp 2011-03-02 18:28:30 [PATCH] Add tab completion support for JOIN
Previous Message Marios Vodas 2011-03-02 17:58:10 Re: Problem with composite type creation in C under Linux