| From: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
|---|---|
| To: | Jim Richards <grumpy(at)cyber4(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SELECT speed with LIKE |
| Date: | 2000-04-04 14:56:34 |
| Message-ID: | 20000404095634.C22876@rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2000-04-04 15:10:46 | Re: Fetching record of the day |
| Previous Message | Sampath, Krishna | 2000-04-04 14:32:17 | nextval(), and serial updates |