Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jflR3-00087i-T1 for pgsql-pt-geral@arkaria.postgresql.org; Mon, 01 Jun 2020 14:29:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jflR2-0002qB-QI for pgsql-pt-geral@arkaria.postgresql.org; Mon, 01 Jun 2020 14:29:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jflR2-0002pM-L6 for pgsql-pt-geral@lists.postgresql.org; Mon, 01 Jun 2020 14:29:04 +0000 Received: from mx3.linea.gov.br ([146.134.17.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jflQz-0006Me-OE for pgsql-pt-geral@lists.postgresql.org; Mon, 01 Jun 2020 14:29:04 +0000 Received: from localhost (localhost [127.0.0.1]) by mx3.linea.gov.br (Postfix) with ESMTP id 22F812F86936; Mon, 1 Jun 2020 11:28:53 -0300 (-03) Received: from mx3.linea.gov.br ([127.0.0.1]) by localhost (mx3.linea.gov.br [127.0.0.1]) (amavisd-new, port 10032) with ESMTP id wDBwwzG-oyfU; Mon, 1 Jun 2020 11:28:51 -0300 (-03) Received: from localhost (localhost [127.0.0.1]) by mx3.linea.gov.br (Postfix) with ESMTP id 036762F86937; Mon, 1 Jun 2020 11:28:51 -0300 (-03) X-Virus-Scanned: amavisd-new at linea.gov.br Received: from mx3.linea.gov.br ([127.0.0.1]) by localhost (mx3.linea.gov.br [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id JlB8lbgZUh96; Mon, 1 Jun 2020 11:28:50 -0300 (-03) Received: from mx3.linea.gov.br (mx3.linea.gov.br [146.134.17.25]) by mx3.linea.gov.br (Postfix) with ESMTP id A75512F86936; Mon, 1 Jun 2020 11:28:50 -0300 (-03) Date: Mon, 1 Jun 2020 11:28:50 -0300 (BRT) From: Carlos Adean To: =?utf-8?Q?Andr=C3=A9?= Ormenese Cc: Comunidade PostgreSQL Brasileira Message-ID: <2082816717.4516.1591021730285.JavaMail.zimbra@linea.gov.br> In-Reply-To: References: Subject: Re: Postgres e CentOS 8 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Originating-IP: [201.17.93.146] X-Mailer: Zimbra 8.8.15_GA_3829 (ZimbraWebClient - FF76 (Linux)/8.8.15_GA_3829) Thread-Topic: Postgres e CentOS 8 Thread-Index: ByeYLWUYAqYPxJ//jzce25zAZagb/w== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ----- Original Message ----- > From: "Andr=C3=A9 Ormenese" > To: "Comunidade PostgreSQL Brasileira" > Sent: Monday, June 1, 2020 10:35:38 AM > Subject: Postgres e CentOS 8 > Bom dia pessoal. > Estou com o PostgreSQL 12.2 instalado em CentOS 8. >=20 > N=C3=A3o =C3=A9 muito frequente, mas muito preocupante, que de tempos em = tempos, mais ou > menos a cada 3 meses, meu hardware fica com alto =C3=ADndice de utiliza= =C3=A7=C3=A3o de CPU. > Acima de 80%, e consequentemente o banco vira uma carro=C3=A7a de roda qu= adrada. >=20 > J=C3=A1 tentei apagar os processos do banco (select=C2=B4s) que est=C3=A3= o retidos e demorando > muito para serem conclu=C3=ADdos, mas n=C3=A3o resolve, a m=C3=A1quina co= ntinua lenta. S=C3=B3 > consigo resolver o problema dando reboot na m=C3=A1quina. >=20 > Por acaso algu=C3=A9m utiliza o CentOS 8, e j=C3=A1 teve esse tipo de pro= blema? >=20 > Obrigado, > Andr=C3=A9 >=20 Seu texto n=C3=A3o diz nada que ajude. Ainda que algu=C3=A9m tenha tido o mesmo problema as causas podem ser compl= etamente diferentes. S=C3=B3 o postgreSQL roda nessa m=C3=A1quina? O alto =C3=ADndice de utiliza=C3=A7=C3=A3o de CPU =C3=A9 resultado dos proc= essos gerados pelo banco? Qual o status das queries (select's) no banco?=20 Qual o status dos processos dos select's no S.O? Ao inv=C3=A9s de interromper os processos n=C3=A3o seria melhor analisar as= queries? etc etc Fica dif=C3=ADcil dar qualquer pitaco sobre um ambiente totalmente desconhe= cido. -- CA