Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5HMdBa36173; Sun, 17 Jun 2001 18:39:11 -0400 (EDT) (envelope-from jliang@tidal.ipinc.com) Received: from localhost (jliang@localhost) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id PAA28180; Sun, 17 Jun 2001 15:39:02 -0700 (PDT) (envelope-from jliang@tidal.ipinc.com) Date: Sun, 17 Jun 2001 15:39:02 -0700 (PDT) From: Jie Liang To: Tom Lane cc: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [SQL] Re: need urgent help In-Reply-To: <12208.992816408@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/104 X-Sequence-Number: 1661 Tom, It comes back very quick now, there might some backend haven't come back before. thanks a lot. Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.stbernard.com www.ipinc.com On Sun, 17 Jun 2001, Tom Lane wrote: > Jie Liang 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >