Re: COMMIT NOWAIT Performance Option - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: COMMIT NOWAIT Performance Option
Date
Msg-id 1172702198.13722.79.camel@dogma.v10.wvs
Whole thread Raw
In response to Re: COMMIT NOWAIT Performance Option  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: COMMIT NOWAIT Performance Option  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
On Wed, 2007-02-28 at 21:13 +0000, Gregory Stark wrote:
> Hm that's an interesting thought. We only really have to check pages that
> would have received a full page write since the last checkpoint. So if we made

Do we ever do a partial page write, or is what you're saying equivalent
to "we only have to check pages that have been written to since the last
checkpoint"?

And if it is the same, can't we get the pages that were written to from
the ctids in the wal records?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Possible Bug: high CPU usage for stats collector in 8.2
Next
From: Joachim Wieland
Date:
Subject: Re: SOC & user quotas