Re: Re. Select with where condition times out

[Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>]

Hi

It can be caused due to Table Bloat, table bloat can slow down queries. Use the pg_repack extension or VACUUM FULL to try ti fix this table bloat issue.

You can refer to following link

https://supabase.com/blog/postgres-bloat

Regards

Kashif Zeeshan

On Thu, Jul 18, 2024 at 2:38 PM sivapostgres@xxxxxxxxx <sivapostgres@xxxxxxxxx> 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.  Need to recover complete data as far as possible.

Any possible way(s) to do this?

BKR Sivaprakash 

Yahoo Mail: Search, organise, conquer