"Thomas H." <[EMAIL PROTECTED]> writes:
> with process explorer i can actually check which postgres.exe instance (in 
> all cases i've checked its just 1 instance, and always just 1 file) holds 
> the lock for the file in question.

So which one is it?

> the postgres instance that holds the lock eventually closes the filehandle 
> after some minutes. the process itself is not killed but continues 
> thereafter.

That sounds a bit like what I'd expect the bgwriter to do, but the
bgwriter is also the one trying to issue the fsync.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to