Re: Re. Select with where condition times out

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Re. Select with where condition times out
Дата
Msg-id CAAPsdhd0Ln==fwX04d+ePoxLheA2LBz7GXgAjcycZQKBPOD6rg@mail.gmail.com
обсуждение исходный текст
Ответ на Re. Select with where condition times out  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления: