Обсуждение: Re: Question about performance

Поиск
Список
Период
Сортировка

Re: Question about performance

От
Vivek Khera
Дата:
>>>>> "MS" == Mauro Scarpa <mauroscarpa@despammed.com> writes:


MS> the id field is the primary key. I have created also an index on wuser
MS> and an index on wurl.

Did you run vacuum to get statistics so the analyzer can decide when
to use the index?

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/