Re: [HACKERS] Overflow of bgwriter's request queue

2006-01-12 Thread ITAGAKI Takahiro
I'm sorry when you have received mails of the same content. I had sent a mail but it seemed not to be delivered, so I'll send it again. Tom Lane <[EMAIL PROTECTED]> wrote: > > I encountered overflow of bgwriter's file-fsync request queue. > I can't help thinking that this is a situation that cou

Re: [HACKERS] Overflow of bgwriter's request queue

2006-01-11 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > I encountered overflow of bgwriter's file-fsync request queue. It occurred > during checkpoints. Each backend would call fsync disorderly in such cases, > so that the checkpoint takes a long time and the performance has decreased. > It seems to happen

[HACKERS] Overflow of bgwriter's request queue

2006-01-11 Thread ITAGAKI Takahiro
Hi Hackers, I encountered overflow of bgwriter's file-fsync request queue. It occurred during checkpoints. Each backend would call fsync disorderly in such cases, so that the checkpoint takes a long time and the performance has decreased. It seems to happen frequently on the machines with a lot of