Re. Select with where condition times out

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: Postgresql General Group <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re. Select with where condition times out
Date: 2024-07-18 09:38:22
Message-ID: 937562047.1752859.1721295502145@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,PG V11
Select count(*) from table1Returns 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.  Need to recover complete data as far as possible.
Any possible way(s) to do this?
BKR Sivaprakash 

Yahoo Mail: Search, organise, conquer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kashif Zeeshan 2024-07-18 09:42:41 Re: Re. Select with where condition times out
Previous Message Laurenz Albe 2024-07-18 07:00:50 Re: Planet Postgres and the curse of AI