Re: SELECT speed with LIKE - Mailing list pgsql-general

From Ross J. Reedstrom
Subject Re: SELECT speed with LIKE
Date
Msg-id 20000404095634.C22876@rice.edu
Whole thread Raw
In response to Re: SELECT speed with LIKE  (Jim Richards <grumpy@cyber4.org>)
List pgsql-general
On Tue, Apr 04, 2000 at 06:30:17PM +1000, Jim Richards wrote:
<nothing, because it was in html>

Boy, _that_ was hard to read. Not only HTML, but lots of   all
over. I _think_ Jim was concerned that selects on his big tables
where not using his indices. The canonical reply question is:

Have you run 'vacuum analyze' recently?

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

pgsql-general by date:

Previous
From: "Sampath, Krishna"
Date:
Subject: nextval(), and serial updates
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Fetching record of the day