Postgres Pro
Downloads
Home   >   mailing lists

WAL segments pile up during standalone mode - Mailing list pgsql-hackers

From Alvaro Herrera
Subject WAL segments pile up during standalone mode
Date
Msg-id 1299085966-sup-8520@alvh.no-ip.org
Whole thread Raw
Responses Re: WAL segments pile up during standalone mode
List pgsql-hackers
Tree view 
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@alvh.no-ip.org>

pgsql-hackers by date:

Previous
From: Marios Vodas
Date:
Subject: Re: Problem with composite type creation in C under Linux
Next
From: Andrey Popp
Date:
Subject: [PATCH] Add tab completion support for JOIN