Skip site navigation (1) Skip section navigation (2)

Re: pg_autovacuum Win32 Service startup delay

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Alvaro Herrera" <alvherre(at)dcc(dot)uchile(dot)cl>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_autovacuum Win32 Service startup delay
Date: 2005-01-25 06:56:30
Message-ID: 004401c502ab$00cff8e0$0a01a8c0@zaphod (view raw or flat)
Thread:
Lists: pgsql-patches
Tom Lane wrote:

> Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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 


In response to

pgsql-patches by date

Next:From: Neil ConwayDate: 2005-01-25 07:05:52
Subject: Re: add soundex difference function to
Previous:From: Kris JurkaDate: 2005-01-25 06:13:07
Subject: add soundex difference function to contrib/fuzzystrmatch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group