Re: pg_autovacuum Win32 Service startup delay

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: 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 00:27:12
Message-ID: 20050125002712.GB28982@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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[(at)]dcc(dot)uchile(dot)cl>)
"Ciencias políticas es la ciencia de entender por qué
los políticos actúan como lo hacen" (netfunny.com)

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-01-25 00:33:43 Re: pg_autovacuum Win32 Service startup delay
Previous Message Neil Conway 2005-01-25 00:22:23 Re: LRU