Need help in Seq Scan

Поиск
Список
Период
Сортировка
От Kishore Arava
Тема Need help in Seq Scan
Дата
Msg-id CANNabade44YC3-s_vJ_SQgdDroHmAS11P9bLFD91nCsp=sOmCA@mail.gmail.com
обсуждение исходный текст
Список 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

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

Предыдущее
От: Prince Pathria
Дата:
Сообщение: Re: HIPAA Business Associate Agreement (BAA)
Следующее
От: Hong Yao
Дата:
Сообщение: many "cp: cannot stat xxx No such file or directory" logs in warm standby