Re: Why is checkpoint so costly? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why is checkpoint so costly?
Date
Msg-id 17436.1119388599@sss.pgh.pa.us
Whole thread Raw
In response to Why is checkpoint so costly?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Can we break down everything that happens during a checkpoint so that we 
> can see where this huge cost is coming from?     Checkpointing should be 
> limited to fsyncing to disk and marking WAL files as recyclable, but there 
> seems to be something more.

I already asked you to measure the thing I think is the likely candidate
(to wit, dumping full page images into WAL).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PROPOSAL FE/BE extension to handle IN/OUT parameters
Next
From: "Magnus Hagander"
Date:
Subject: pg_terminate_backend idea