Re: Question about performance

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about performance
Date: 2003-04-25 03:02:53
Message-ID: x7n0if5leq.fsf@yertle.int.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "MS" == Mauro Scarpa <mauroscarpa(at)despammed(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-25 03:08:11 Re: Solaris
Previous Message Andrew Sullivan 2003-04-25 02:54:50 Re: Solaris