Re: Latch for the WAL writer - further reducing idle wake-ups. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Latch for the WAL writer - further reducing idle wake-ups.
Date
Msg-id 11231.1336016560@sss.pgh.pa.us
Whole thread Raw
In response to Re: Latch for the WAL writer - further reducing idle wake-ups.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Latch for the WAL writer - further reducing idle wake-ups.
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> ... It seems unlikely to cause any real
> problem if WAL writer takes a couple seconds to get with the program
> after a long period of inactivity; note that an async commit will kick
> it anyway, and a sync commit will probably half to flush WAL whether
> the WAL writer wakes up or not.

That's a good point.  What about only kicking the WAL writer in code
paths where a backend found itself having to write/flush WAL for itself?
The added overhead is very surely negligible in such a situation.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Torn page hazard in ginRedoUpdateMetapage()
Next
From: Vivek Singh Raghuwanshi
Date:
Subject: Re: Features of Postgresql and Postgres-xc with MySQL