Re: Question about performance - Mailing list pgsql-general

From Vivek Khera
Subject Re: Question about performance
Date
Msg-id x7n0if5leq.fsf@yertle.int.kciLink.com
Whole thread Raw
List pgsql-general
>>>>> "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/

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Solaris
Next
From: Tom Lane
Date:
Subject: Re: Solaris