Re: pg_autovacuum Win32 Service startup delay - Mailing list pgsql-patches

From Michael Paesold
Subject Re: pg_autovacuum Win32 Service startup delay
Date
Msg-id 004401c502ab$00cff8e0$0a01a8c0@zaphod
Whole thread Raw
In response to pg_autovacuum Win32 Service startup delay  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-patches
Tom Lane wrote:

> Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
>> On Mon, Jan 24, 2005 at 06:57:54PM -0500, Tom Lane wrote:
>>> (Five minutes at least has a defensible rationale, ie it's the default
>>> checkpoint interval and we expect we can replay the log at least as
>>> fast as it was created initially.)
>
>> Hmm, I remember Mark Wong from OSDL saying that it took to replay the
>> logs after a crash more than the six hours it had taken to generate
>> them.
>
> Six hours?  Did he have checkpoints disabled somehow?

No, I remember they were talking about recovery from backup using PITR.
(i.e. not simple crash recovery, but replaying the logs from the whole
benchmark session)

Best Regards,
Michael Paesold


pgsql-patches by date:

Previous
From: Kris Jurka
Date:
Subject: add soundex difference function to contrib/fuzzystrmatch
Next
From: Neil Conway
Date:
Subject: Re: add soundex difference function to