Postgres Pro
Downloads
Home   >   mailing lists

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

From Raj kumar
Subject Improve "select count(*)" query - takes more than 30 mins for some large tables
Date
Msg-id CACxU--UJY4sD2SjW8V3W0oAPuuTzE3fAvBzTaej-BmUUNJxN_Q@mail.gmail.com
Whole thread Raw
Responses Re: Improve "select count(*)" query - takes more than 30 mins for some large tables
Re: Improve "select count(*)" query - takes more than 30 mins for some large tables
List pgsql-admin
Tree view
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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Storing large large JSON objects in JSONB
Next
From: Florents Tselai
Date:
Subject: Re: Improve "select count(*)" query - takes more than 30 mins for some large tables