index skipped in favor of seq scan.

Поиск
Список
Период
Сортировка
От ryan.a.roemmich@mail.sprint.com
Тема index skipped in favor of seq scan.
Дата
Msg-id H0001cb70b98181a.0994709792.kcopmp06@MHS
обсуждение исходный текст
Ответы Re: index skipped in favor of seq scan.  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
I am working with putting syslog logs into a database, I'm parsing the
logs and using the key information for my fields.  With my test data of
~200K rows the optimizer used my b-tree index that I created for an
oft-used where clause.  When the table grew to over 800K rows the index
was no longer used.  The field in question contains IP addresses, but
uses varchar.  The values are _not_ unique.  One particular address has
150K entries.  How can I keep my where queries speedy?

-ryan


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

Предыдущее
От: "Matt Block"
Дата:
Сообщение: dump
Следующее
От: "Mihai Gheorghiu"
Дата:
Сообщение: Interfacing with MSAccess