quest:optimization with indexes

Поиск
Список
Период
Сортировка
Искать
От
Clayton Cottingham
Тема
quest:optimization with indexes
Дата
Msg-id
37B0AAE0.926AE58D@smartt.com
Список
Дерево обсуждения
Re: [SQL] quest:optimization with indexes Clayton Cottingham <drfrog@smartt.com>
Re: [SQL] quest:optimization with indexes Tom Lane <tgl@sss.pgh.pa.us>
hello,
im looking for info/help on creating indexes
im using 6.5
we have a table overe 100,000 rows

if we put in an index or not an explain say it still does a seq scan,
same amount of time taken!

ive tried putting the index using just the oid , a combo of some fields
of our data using btree

where/what rules should be followed for setting up a good indexing
scheme under pg?



В списке pgsql-sql по дате отправления
От: Evan Simpson
Дата:
От: Clayton Cottingham
Дата:
FAQ