Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qv4tM-0033EZ-QP for pgsql-general@arkaria.postgresql.org; Tue, 24 Oct 2023 00:03:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qv4tK-0002pJ-3d for pgsql-general@arkaria.postgresql.org; Tue, 24 Oct 2023 00:03:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qv4tI-0002n9-L6 for pgsql-general@lists.postgresql.org; Tue, 24 Oct 2023 00:03:26 +0000 Received: from rs6162.luxsci.com ([162.142.76.255]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qv4tF-002Mv5-Bc for pgsql-general@lists.postgresql.org; Tue, 24 Oct 2023 00:03:24 +0000 Received: from pfortin.com (h199.241.136.40.dynamic.ip.windstream.net [40.136.241.199]) (authenticated bits=0) by rs6162.luxsci.com (8.15.2/8.14.9) with ESMTPSA id 39O03GIP2701803 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Tue, 24 Oct 2023 00:03:17 GMT Date: Mon, 23 Oct 2023 20:03:16 -0400 From: pf@pfortin.com To: pgsql-general@lists.postgresql.org Subject: Re: Disk wait problem... Message-ID: <20231023200316.194b9e3d@pfortin.com> In-Reply-To: <9938ff1a-8837-454b-a50c-a748e84c172a@aklaver.com> References: <20231023145459.143faba7.pfortin@pfortin.com> <20231023175529.59f309bb@pfortin.com> <9938ff1a-8837-454b-a50c-a748e84c172a@aklaver.com> X-Mailer: Claws Mail 4.1.1git67 (GTK 3.24.38; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Lux-Comment: Message 39O03GIP2701803 sent by user #22429 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pfortin.com; h=date:from:to:subject:message-id:in-reply-to:references:mime-version:content-type:content-transfer-encoding; s=dkim; bh=N/IbVBX5ohlcxnlECHiTYdIsmCqlDxSLOoUvCysfiTM=; b=ra4FH6OYtX78agX2j2pW8a1Z7kwNKPXGK4xWKWOoPGe4zsucwYdGuWAnWV0DpU/SOSGdgHkRLVwJSzl5VK3k69S93o6Zy15aeXoYyiGYdz2TxPqPQK3bbTsbRYKSvHvzip8FVEdN2UDQPl5HNtMvI8ZdtE0IaOZXIL1RPP7ecBM= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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