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 по дате отправления