Home > mailing lists

Re. Select with where condition times out - Mailing list pgsql-general

From	sivapostgres@yahoo.com
Subject	Re. Select with where condition times out
Date	July 18 12:38:22
Msg-id	937562047.1752859.1721295502145@mail.yahoo.com Whole thread Raw
Responses	Re: Re. Select with where condition times out Re: Re. Select with where condition times out Re: Re. Select with where condition times out
List	pgsql-general

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. Need to recover complete data as far as possible.

Any possible way(s) to do this?

BKR Sivaprakash

From: Laurenz Albe
Date: 18 July, 10:00:50
Subject: Re: Planet Postgres and the curse of AI

From: Kashif Zeeshan
Date: 18 July, 12:42:41
Subject: Re: Re. Select with where condition times out