Re: clog_redo causing very long recovery time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Joseph Conway <mail(at)joeconway(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: clog_redo causing very long recovery time
Date: 2011-05-09 13:39:46
Message-ID: 28657.1304948386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> I agree with Tom about the need for a fix that prevents generation of
> repeated WAL records.

> OTOH, I also like Joe's fix in the recovery code to avoid responding
> to repeated records.

> Can we have both please?

Why? The patch in the recovery code is seriously ugly, and it won't
do anything useful once we've fixed the other end. Please notice also
that we'd need several instances of that kluge if we want to cover all
the SLRU-based cases.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-05-09 13:44:31 Re: "make check" in src/test/isolation is unworkable
Previous Message Roberto Mello 2011-05-09 13:20:50 Re: [HACKERS] Re: New Canadian nonprofit for trademark, postgresql.org domain, etc.