Postgres Pro
Downloads
Home   >   mailing lists

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

From Kashif Zeeshan
Subject Re: Re. Select with where condition times out
Date
Msg-id CAAPsdhd0Ln==fwX04d+ePoxLheA2LBz7GXgAjcycZQKBPOD6rg@mail.gmail.com
Whole thread Raw
In response to Re. Select with where condition times out  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
Tree view
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

Regards
Kashif Zeeshan

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

Any possible way(s) to do this?

BKR Sivaprakash 

pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re. Select with where condition times out
Next
From: Durgamahesh Manne
Date:
Subject: Re: Regarding vacuum freeze locking mechanism