| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2005-01-25 07:05:52 | Re: add soundex difference function to |
| Previous Message | Kris Jurka | 2005-01-25 06:13:07 | add soundex difference function to contrib/fuzzystrmatch |