Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f5HMKIa30576;
	Sun, 17 Jun 2001 18:20:23 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f5HMK9312211;
	Sun, 17 Jun 2001 18:20:09 -0400 (EDT)
To: Jie Liang <jliang@ipinc.com>
cc: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org
Subject: Re: [SQL] Re: need urgent help 
In-reply-to: <Pine.BSF.4.10.10106171451560.95993-100000@tidal.ipinc.com> 
References: <Pine.BSF.4.10.10106171451560.95993-100000@tidal.ipinc.com>
Comments: In-reply-to Jie Liang <jliang@ipinc.com>
	message dated "Sun, 17 Jun 2001 15:13:36 -0700"
Date: Sun, 17 Jun 2001 18:20:08 -0400
Message-ID: <12208.992816408@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200106/103
X-Sequence-Number: 1660

Jie Liang <jliang@ipinc.com> writes:
> I vacuumed urlinfo already.

VACUUM ANALYZE, or just VACUUM?

> urlinfo_pkey is primary key (id), urlinfo_ukey is unique key (url)
> when I:
> SELECT id FROM urlinfo WHERE url='http://*.yahoo.com';
> It seems taking me longer than before.

What does EXPLAIN say about it?

			regards, tom lane