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 1sVkwW-00BUEp-NW for pgsql-general@arkaria.postgresql.org; Mon, 22 Jul 2024 04:46:37 +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 1sVkwU-00Emsm-Dw for pgsql-general@arkaria.postgresql.org; Mon, 22 Jul 2024 04:46:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sVkwT-00Emo8-PL for pgsql-general@lists.postgresql.org; Mon, 22 Jul 2024 04:46:34 +0000 Received: from sonic301-19.consmr.mail.sg3.yahoo.com ([106.10.242.82]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sVkwN-000nan-7y for pgsql-general@lists.postgresql.org; Mon, 22 Jul 2024 04:46:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1721623581; bh=XP8MdPwj4t6l43n1VUr2L3ycnobIyKWbZbzhaV26jJw=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=q63aRzbcTqYN2SxfGUkSjzyN1CU7ZYl/Mxn3VEvDygoyXVQR0N+K0khVEWUdzDAmeahM3yACMLKMPjPzqNRBrORjSy68fuuyzwMwL/43cX0wuyB5BpzUPOdAfGjLC0bMVgNhsKp+1hSljFHewsdXc6rnQi03h77mMwASLoxXg2cciZZ9eJGgd2dCBdW9aBh98SafvW5LPlWBEOkk4/s4cVWYIWBHz5zWfNrOD8XnH4TR1fFfO+NkZpUWMk8HAZnAf629lUfVV/NG6Exaw37s7+CGe1n9a8LtN09/oZ7pAT/EyhWW+XMo6f/mGWeorn3Oht9Ff1pKDo8DgTtHYAeJHw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1721623581; bh=vcZZG4VYhm1Ok6B9mT5LX5CJC6RS07Rzokb7TWIzC8d=; h=X-Sonic-MF:X-Sonic-MF:Date:From:To:Subject:From:Subject; b=MEMGsHIO/6rQ7CVmwmb3ldqYSjhY/4LB83MzNF3my6pt3D7GxTahjr0Rep+zhvDAUVixWvz+7k0GCRN98+g33iFe3Vv3GJcQppeVvi4rVP0FxoJ2OktsHI+zVoyI9fF9rP6+8vusIkPUNQfgo4KcXBqbZNy2yLKR+HSmIGcWEa1oCJg2HVJbj829DcfkmVXDqSwOxLwyr2BFGZ/4oGMLEBDQkInpU37B4sIT3NYxTIQkiUDa+qmEBdHucixitO4ErSzipO53tZZc/QpvOOl06r9EUXXz2eeB+DBTujzI+zebBljIsaQkTpAkCjzkq/4ZrIp6tQx0iFvwshv1mgkHkg== X-YMail-OSG: rt9mM_MVM1mJ_Ui6PNeHPsRYXPNZWJf4bI7tOoHvSKZ.QL4Jf1hr5gtNpC9k.oX qDf9Pgp29mt0hRP4zgIAD16CXcy6kyBK6qaf4hFa0DwjqMXvsan46Ip6nC2Qwdjufv_PaZaAjg5U lt4eja54F6R3cPhSmgZ3D1CSkdUAilIwq6fB67_eNcpqtsLPWGcpqNYAb5yGnYN3G9iOSmmGXEDn p5pUMpKdDue3abP6o0MrcaSrQUq5rS6DTiVfgqOC3LBxWFyEmAZhg4Sa.S_aggt5Qwf4OqfuMoge f.4DCqIwmiQISB8zOCygJy.Pwyi1_8C2B_osy8lNYAilwul6agVTOdgn9u1CSnuXWl8vX79yAnvF sblKaNjklcWMZqw8n9o8UL5QsQ2Hr7.EO.7540dyfJWkwvvc7UmTcgkoOkEJH1wQO7hMOlQK2ybl NQomtQB6wBxTTvoVB_A9tnatEdxi7tusk4jCPRJBs39CBf3iHXS94bbRhH8GOp0ehSJWrAQ8MHso bHm1VykPbfeQ1VPQWJF32EemMAiXb7N4QAW04uS7id8MjHH.u3Jgq53R4VuTC1kYJA1BudM5Rf0Y 1wBVFi8L.2UC.c6Q6LTKyAJwlBa1zaEAAlQAUVCauIm__Taz9LcgSSCuMo8NuiPJBHkGZ.xopYOn 8zxKKiGi68u6db8xSyBAPhBUaYgDUC0fcWM1DDwp8EV3cgS7gaX9PrbdjbGjM5Vo64mzsnwgEoEI IImTD8abBg6lf7djNJwhaSjXmfczsFHIqZ9Ff4Ym5kkOhmH9qSzNDB6UX.nIl6Wbzcd2CS_srxqL 27Bx.WEllKED2MfgWOKGhHw3my7ibwHKawJuyCR7McYEs.xE2ls1lI79kOtNJTEL0LxIjnvFIuW8 D2fDXxN_PYq2qjgVrTt5PToFxTkC3TS4dgjwe8kz4Q.YlS0hgFOt0sdN4UbqrRXbTimGC4AIl5It fxPa2XnCj3ccugeSXuYqzrXwU9zOBE8M5nMwm7.6XNzFhQtDOlqmOy7kEc389qurHSSIXeuoIIXn t58QBeTKxu4YtfxDZBYLL9..WeBUttVaMdzrH2agN25H3KLALgsQcLzzHsaiPcTTtRpf8QqrS0yW bqeD_7_kMznxTrUGva2IZsFFidC6IbF4_jzSdd8.XHrrDo9QiCuuk7C38U8SP4ZVQ1Sab_eCdEa2 F2UEeRloYWUna4vctVlXziZUieqTqtIOIZ5qA.6dwsD5xrlBRm.ocwyQquvzVlxZX2AmBf7yAEiU o5lP.g9l2wr4s2sg_vepJK6mXqfXDq5BuN2UUNSZV5wloUCyZElRiQJFJBVWNgEnZ_gE7DG6cTS0 Yn.TmVOpfcjmaRvRdpVXsfMZKlDHNQigqnJFibqzHnDlt5cKgOPeA._OipKj0iLONQ2I9LHadtNk kpjf7KItbZKM2y..3NRBjPJJ1Cx.RSAg5ivdtR502VMOg5wZFsV6_a2fL.AE7pqZHOjH_5pZw4uB TEKA0wlHNTtLzXm5mV84rmef9XJJyeAT33A09u.PJ6VopELD9m8BdIJ3lY9NZx23tWLVfdiYgUup e2VofNvNvD7_HcOJCwYNMShQM_x.5qZDoWaIYdVgH_mxYAbZY.Par.pz2An0.GvJyQ7XkKqdt.SR kN4l1QOv8rwTHO4h.CQRHLh2JskPMJwFhbCkSSdhUcqJDLHpdL3Mg6F918eCeZPKygaARS4xh4zR fqpkSoqKVT1J.RLoYVz4.0yAH4m4crNR_wP7j.nph0Iqmm4ULLzqEROQ4417HmIu_LS0EbwS3Ckt V4RvxVlhBrciQF1qU2kIYry0TmcSPDHk52hPfqy1K688WkhUIcQasnvppCN4RLVR6otjEov6kS7v B18OQ.uVLUOraDduOfm3qRdz3slGmq83OFJkEnyyVS9Xx5fqJ76ui3OATAPLyZPzZmyYFx_qumpn CRnTimAXfeUjxv35Fo0niTzuRJWkE1C8pRMgudV8RoeDF8ePyLOXH5.SvXCobjn6_oD0fGwAl4M4 JAUxWnaVVJ_zTMEzzMEFX2RHOfKuMeoTam6Oe_B53QTUuxUkVgXntEovk_O_ROhHJbM2hpmRgo4E JFfJ8PbFbzDVNqwXXtoQZHEWREsPlL0O4bCgs1ClpeRCzBGB4NKRUn9aR3STAj0vS57a4_KxjISO mN8lEwhLBtOna7qRQKyRvLiiAwkvI2PVLfj30yqd1jHNJvZmC.uIi.MZZJY_WQmDDacZoREjZWJc 0ONv_89jep8N_q3yyNB5h7O4IRc.ppPudZkAZpnNjdyu3zPu6hRHlN5uTHIvaQwHT7GM8p9f68rr nzDU3LvdzM6IRPDWwd24- X-Sonic-MF: X-Sonic-ID: 65102234-1367-4a29-92c3-28107bb4a18a Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.sg3.yahoo.com with HTTP; Mon, 22 Jul 2024 04:46:21 +0000 Received: by hermes--production-gq1-799bb7c8cf-77nhs (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID af19e0db8c847c111c7a5998185e935f; Mon, 22 Jul 2024 04:46:18 +0000 (UTC) X-YMail-OSG: PEmb0zMVM1mNxda4B6poPNG7NYUQZwXd6Y3lLbB9rZj3wBUVUW.zrLd9GPnPoX_ 9VmrGnzCfOyZnMD5K_iSRvEjFdjV_VDx1zWjvlzkyVzEpDB6rW8yvd7Uf4eZtEYO2OYZKTqZBAGz pRh3EeP37PLuVAq_VJtd4c6Dzp4MU6AGbMJtuaC8UHuHtx.HszJQQhmoGlsgT1m2M5KP4_2DXJhr RBauZ0OUDd7ndYkrhJ.YOoIrovBVRTwGwFMHVsfW1RC7j2kOsb99Gfc12uM7TOESk57WhYYOLKGb F6ln68aN2xb2A_1wvlGZVfLwNYg7aKn8uEZg94tDE5pRENOsjWMmizO0jUc1l93ZQ3_wgRMrellU upS30xx9feyOCP3ubvCdchX1ylUe2_0FQHfWRLexWzdJ9IDJoM.dNZczuXh8bvgHYAcl6pIHOPhM Javx8xH5HNmcZOG4Yc7a0pkQn03CdxJHVTHIZp5X0D3Qa6llQrxWSJcDee2ZJvZhF_HmAjjNI0Fi MnmeN4YBexXMjkmrAt.L4lSDtjyFwpUmImjQZz7HzqlzoHjzhYJ0BQ6ciDgJT8y6PYHWWYa1ZAnk SNXhlQJSlaxGiANWVtE7NxWfQLWnTEj7h.ZiRXhxriTTn_gIU8jUca1cBUGdC4rlMZbmLhl_8RkT ItMwWK_XEg3yHqG3o.PkUCO9P2XYa6MnjfUc3jErRC3QfVpO1FOzKd8LJgnaL.2FkFFjkjIcUb6i fTIrpnzyOI.Tb5kzaLRmeRghDCq0Wl6cRElTztwcS9sc6mJ3YvBC_AiOnCGexbpH9y02v1MB_Sbm X67jG2zz0Aoi0eP7Ly_VnGlIYQmlGqlFS_U9Dyuw3FUPCcZBvVdB5kjEm8oV5mHiI9EFmAkcJ_si XYy9X.8foCOjd9IKtoJPGtny1aWRhjXcJ8VRoki8jgPNViVAtioY98gRbZAXhu3yZDvuOu3CFFQJ fvtFHH8F2_FvQZNuGjx8UcDN05Po30WS3VVuZC9D4scXnEJSWaBvqNuJVznKrgYivXPnBg0lNS.F GWkfYhl_E8cbSYXGoSwq2AlggeqF6Got6PeZC2fqIuEBlZtxFtCRJkKfVCpvhcaJnNmelZaD.qYj dQQKHPvg5WRkG86Nuae_nI6Vqj1AQ8nt4JsFlxds7SBjc_b8ioPKRE6UJOI5kUKTI.0Fr9bwk70W C0Gt19bmON_WYYI_WgzP1KExWK9geOQ9NP_D0kzndMMO6b.RebcV3zP2iYwgRAOKYS9T2pnm6mWS t1hoU0hH4wgh5inibdtj6RAilb4Ef5ECepuoSAzIX3X0yVNtJOlgjUsla.EUVQ2aAI1_NdZTkXEq EawPu0vEr3IJT_Rk3td1aK39nNAGb9vidfBdggb4NrzHTch_jSISNFQw8ai0pUMbC5R.sWj1YZY0 1aWa1N84su4HFY1xFJscmUYeSgZXwkF1E5eRzztuBiBzoy6qpRGLYNFfAki2bRtwQvjzOaJCPwwj FCOfooJdzW.LTKdCfaBettxezfwpQ2P9rWcBM8Um0aqnPLxe3yxpsheGidpddri0.jCmvrfCSTXp lBJ03QG.6qCszp0E5Otoc4fyg.s2G4fXhkBm3Nz2HxsYAh4gZUNQBPlPbyZFvETnlktIgFWbfco0 RDgJw6_W1UtCo7fMReWTyW_bEwvKpIVRSP.9pzbvaIBy2SyJOkWUzcNDniTkNWcxXzP.w30Q2shn ZzRi_8o9HYUbrx1TTNNY7o8_0yv2etN2d_5byHhPygg0iplfV83H2oX.iIPCwLPfsybWxqQR7XWR mDEpESu5A4.DAmoEUR6WY1D8vFT4Mfs3_i9A15jWmG1_esg.2EA02aRKWK1g2aZj_BOsXc8HpUlV oTOub3XuX6DnnMmyYnioP7o8a7qbTBsUfQW9MXNnkxPbvwoFBJ98zAMxxFu2Le3H1ApoV_KMDlb6 yR0.rFWJ0JEIwGGx8XmDPLlKGhw_CpXRG8mKuxBWpppOWEu2ao1SOxxW7DC7J7caSQyCif3yC2y5 SLVTCDuR24CQvGBWChmB9aKuIzcqKvANux7wbkYTAnV.QetxyKsnptvl7n0VKu6QiXblu7g2g9e4 BFB78pupJbw_dbwEojdleWFJhk9D8HXuoi0QCh6m7cBDHicwjoSnQVm7QubvPNzG6q10BMSpzWCR jXwZnbcmdF59i1qangbbntKCyAUZiJwMZ4DFympvRddZqPnqz43azOmafQND4fC.fhZx7tjOYeEV KwBnpV0Nt0KAFvh1fVD17iKyuliXlTA1tvOpanUTPL1RnXNhvRQZuekZtwp_3TfkbBm4hQCN1dtz 6vQbUXiTubvpSmHzOdXuy78bny1sx3x2PaNDDvKYVC6rkkgcUvTLkGH.iGKay729Y_QZ9pzYBa1z svguHA9JlPL.RWqMC_Afk X-Sonic-MF: X-Sonic-ID: fa7c6478-d861-4d9c-a3ed-1d04989d0204 Received: from sonic.gate.mail.ne1.yahoo.com by sonic318.consmr.mail.gq1.yahoo.com with HTTP; Mon, 22 Jul 2024 04:46:16 +0000 Date: Mon, 22 Jul 2024 04:46:13 +0000 (UTC) From: "sivapostgres@yahoo.com" Reply-To: "sivapostgres@yahoo.com" To: Michael Nolan Cc: Postgresql General Group Message-ID: <966329222.2773804.1721623573663@mail.yahoo.com> In-Reply-To: References: <937562047.1752859.1721295502145.ref@mail.yahoo.com> <937562047.1752859.1721295502145@mail.yahoo.com> Subject: Re: Re. Select with where condition times out MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2773803_1624558956.1721623573661" X-Mailer: WebService/1.1.22501 YMailNorrin Content-Length: 5589 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2773803_1624558956.1721623573661 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =20 On Sunday, 21 July, 2024 at 12:52:22 am IST, Michael Nolan wrote: =20 =20 On Thu, Jul 18, 2024 at 4:38=E2=80=AFAM sivapostgres@yahoo.com wrote: > > Hello, > PG V11 > > Select count(*) from table1 > Returns 10456432 > > Select field1, field2 from table1 where field3> '2024-07-18 12:00:00' > Times out > > The above query was working fine for the past 2 years. > > Backup was taken a day back.=C2=A0 Need to recover complete data as far a= s possible. > > Any possible way(s) to do this? > > BKR Sivaprakash > If you do a full backup, does it complete in a normal manner and the usual = time? Have you tried doing a shutdown and restart of the database, or possibly rebooting the server? You may need to alter the database server settings to increase the maximum query time. Mike Nolan htfoot@gmail.com 1.=C2=A0 Full backup taken without any issue.=C2=A0 Checked it by restoring= as another database in the same server.=C2=A0 No Issues. 2.=C2=A0 PG Service stopped and re-started.=C2=A0 =C2=A0 Re-booted the serv= er also.=C2=A0 Same issue. 3.=C2=A0 PG is working with default settings only, that's set during instal= lation time.=C2=A0=C2=A0 When the query was run in the restored database, in the same server machine= , the query executed in a second.=C2=A0 The same query, in original databas= e, takes more than 15 min.=C2=A0=C2=A0 BKR Sivaprakash =20 ------=_Part_2773803_1624558956.1721623573661 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


=20
=20
On Sunday, 21 July, 2024 at 12:52:22 am IST, Michae= l Nolan <htfoot@gmail.com> wrote:


=20 =20
On Thu, Jul 18, 2024 at 4:38=E2=80=AF= AM sivapostgres@yahoo.com

<sivapostgres@yahoo.com> wrote:
>
> Hello,
> PG V11
><= br clear=3D"none">> Select count(*) from table1
> R= eturns 10456432
>
> Select field1= , field2 from table1 where field3> '2024-07-18 12:00:00'
> Times out
>
> The above q= uery was working fine for the past 2 years.
>
> Backup was taken a day back.  Need to recover complete = data as far as possible.
>
> Any = possible way(s) to do this?
>
> B= KR Sivaprakash

>

If you do a full backup, does it complete in a normal manner and the = usual time?

Have you tried doing a shu= tdown and restart of the database, or
possibly rebooting = the server?

You may need to alter the = database server settings to increase the
maximum query ti= me.

Mike Nolan
htfoot@gmail.com

1.  Full backup taken without any issue.  Checke= d it by restoring as another database in the same server.  No Issues.<= br>2.  PG Service stopped and re-started.    Re-booted the s= erver also.  Same issue.
3.  PG is working with default settin= gs only, that's set during installation time.  

When the query was = run in the restored database, in the same server machine, the query execute= d in a second.  The same query, in original database, takes more than = 15 min.  

BKR Sivaprakash

------=_Part_2773803_1624558956.1721623573661--