Improve "select count(*)" query - takes more than 30 mins for some large tables

Поиск
Список
Период
Сортировка
От Raj kumar
Тема Improve "select count(*)" query - takes more than 30 mins for some large tables
Дата
Msg-id CACxU--UJY4sD2SjW8V3W0oAPuuTzE3fAvBzTaej-BmUUNJxN_Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Improve "select count(*)" query - takes more than 30 mins for some large tables  (Florents Tselai <florents.tselai@gmail.com>)
Re: Improve "select count(*)" query - takes more than 30 mins for some large tables  (Holger Jakobs <holger@jakobs.com>)
Список pgsql-admin
Дерево обсуждения
Hi,

How can I improve "select count(*)" for larger tables? I'm doing a db migration and need to validate the data count.
"select count(*) " queries are taking more than 30 minutes for some tables which is more than the downtime we have.
Will work_mem increase help? or how can i speed up this row count?

Thanks,
Raj

В списке pgsql-admin по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Storing large large JSON objects in JSONB
Следующее
От: Florents Tselai
Дата:
Сообщение: Re: Improve "select count(*)" query - takes more than 30 mins for some large tables