Re: Disk wait problem...

Pierre Fortin <pf@pfortin.com>

From: pf@pfortin.com
To: pgsql-general@lists.postgresql.org
Date: 2023-10-24T00:03:16Z
Lists: pgsql-general
On Mon, 23 Oct 2023 16:31:30 -0700 Adrian Klaver wrote:

>Please reply to list also.
>Ccing the list for this post.

Sorry, got the list's message and one directly from you; looks like I
picked the wrong one to reply to...

I just heard from a remote team member who wrote this:
    !! Eventually found that 3 PG processes are sitting in disk-wait 
	(attached
    !! screenshot)... I still can't imagine what would hold onto a
	disk for that
    !! long,

    I wonder if these are abandoned queries that did not properly close
    out.

He forgot to attach his screenshot; trying to get more info from him... 

Thanks,
Pierre