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

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 (view raw or flat)
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

pgsql-patches by date

Next:From: Tom LaneDate: 2005-01-25 00:33:43
Subject: Re: pg_autovacuum Win32 Service startup delay
Previous:From: Neil ConwayDate: 2005-01-25 00:22:23
Subject: Re: LRU

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