| From: | Kishore Arava <kishorearava111(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Need help in Seq Scan |
| Date: | 2020-09-25 11:41:09 |
| Message-ID: | CANNabade44YC3-s_vJ_SQgdDroHmAS11P9bLFD91nCsp=sOmCA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I have a table in my schema with 5M rows with some columns indexed. When I
do a search on a column it is going for Seq scan instead of index scan as
the filtered values are more and got convinced from
https://www.cybertec-postgresql.com/en/postgresql-indexing-index-scan-vs-bitmap-scan-vs-sequential-scan-basics/
.
Can someone help me in making the Seq scan faster?? As it is taking 5min to
scan over that 5M rows of data.
Thanks in Advance.
Kishore Arava
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hong Yao | 2020-09-28 05:12:08 | many "cp: cannot stat xxx No such file or directory" logs in warm standby |
| Previous Message | Prince Pathria | 2020-09-24 15:39:05 | Re: HIPAA Business Associate Agreement (BAA) |