Simon Riggs <[EMAIL PROTECTED]> writes:
> On Thu, 2004-07-22 at 01:44, Tom Lane wrote:
>> Agreed. Maybe it should be part of the bgwriter's idle loop, and
>> not directly associated with checkpoints at all.
> Yes, thats a more natural home, now bgwriter exists. But does it know
> when log files are full? How would it know?
It can run PreallocXlogFiles --- or more likely a modified version of
same. There isn't anything that function needs to do that the bgwriter
can't do (in fact, the bgwriter is what runs checkpoints now...)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
