Date: Thu, 18 Jul 2024 09:38:22 +0000 (UTC)
From: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
Reply-To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
To: Postgresql General Group <pgsql-general@lists.postgresql.org>
Message-ID: <937562047.1752859.1721295502145@mail.yahoo.com>
Subject: Re.  Select with where condition times out
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_1752858_2035989826.1721295502144"
References: <937562047.1752859.1721295502145.ref@mail.yahoo.com>
Content-Length: 1631
Archived-At: <https://www.postgresql.org/message-id/937562047.1752859.1721295502145%40mail.yahoo.com>
Precedence: bulk

------=_Part_1752858_2035989826.1721295502144
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello,PG V11
Select count(*) from table1Returns 10456432
Select field1, field2 from table1 where field3> '2024-07-18 12:00:00'=C2=A0=
Times out
The above query was working fine for the past 2 years.=C2=A0=C2=A0
Backup was taken a day back.=C2=A0 Need to recover complete data as far as =
possible.
Any possible way(s) to do this?
BKR Sivaprakash=C2=A0

Yahoo Mail: Search, organise, conquer
------=_Part_1752858_2035989826.1721295502144
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hello,<div>PG V11</div><div><br></div><div>Select count(*) from table1</div><div>Returns 10456432</div><div><br></div><div>Select field1, field2 from table1 where field3&gt; '2024-07-18 12:00:00'&nbsp;</div><div>Times out</div><div><br></div><div>The above query was working fine for the past 2 years.&nbsp;&nbsp;</div><div><br></div><div>Backup was taken a day back.&nbsp; Need to recover complete data as far as possible.</div><div><br></div><div>Any possible way(s) to do this?</div><div><br></div><div>BKR Sivaprakash&nbsp;</div><div><br><br><div id="ymail_android_signature"><a id="ymail_android_signature_link" href="https://mail.onelink.me/107872968?pid=NativePlacement&amp;c=Global_Acquisition_YMktg_315_EmailSignatureGrowth_YahooMail:Search,Organize,Conquer&amp;af_sub1=Acquisition&amp;af_sub2=Global_YMktg&amp;af_sub3=&amp;af_sub4=100000945&amp;af_sub5=OrganizeConquer__Static_">Yahoo Mail: Search, organise, conquer</a></div></div>
------=_Part_1752858_2035989826.1721295502144--