SEO

#1 (**permalink**) 04-17-2008, 11:00 PM

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. Simon commented that it was unexpected, but there was no further
comment on the issue.

(On his test the server is generating the logs as fast as it can, so it
may not be important, but anyway ... )

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Ciencias políticas es la ciencia de entender por qué
los políticos actúan como lo hacen" (netfunny.com)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

#2 (**permalink**) 04-17-2008, 11:00 PM

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: pg_autovacuum Win32 Service startup delay