Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
I admit I have no idea why these guys seem to run into wraparound
problems so much.
On the other hand, I'm not sure that it would work to try to checkpoint
during vacuum, because the backend is in a transaction. Maybe it
Excerpts from Fujii Masao's message of mié mar 02 22:44:45 -0300 2011:
On Thu, Mar 3, 2011 at 3:22 AM, Alvaro Herrera alvhe...@alvh.no-ip.org
wrote:
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
On Thu, Mar 3, 2011 at 9:15 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Fujii Masao's message of mié mar 02 22:44:45 -0300 2011:
On Thu, Mar 3, 2011 at 3:22 AM, Alvaro Herrera alvhe...@alvh.no-ip.org
wrote:
I noticed that in standalone mode, WAL segments don't seem to
Excerpts from Robert Haas's message of jue mar 03 11:18:38 -0300 2011:
On Thu, Mar 3, 2011 at 9:15 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Fujii Masao's message of mié mar 02 22:44:45 -0300 2011:
On Thu, Mar 3, 2011 at 3:22 AM, Alvaro Herrera
Alvaro Herrera alvhe...@commandprompt.com writes:
I admit I have no idea why these guys seem to run into wraparound
problems so much.
On the other hand, I'm not sure that it would work to try to checkpoint
during vacuum, because the backend is in a transaction. Maybe it
would work to force
On Thu, Mar 3, 2011 at 10:16 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Robert Haas's message of jue mar 03 11:18:38 -0300 2011:
On Thu, Mar 3, 2011 at 9:15 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Excerpts from Fujii Masao's message of mié mar 02 22:44:45
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
On Thu, Mar 3, 2011 at 3:22 AM, Alvaro Herrera alvhe...@alvh.no-ip.org wrote:
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.
Checkpoint is required to