| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Garrett Bladow <bbladow(at)sendit(dot)nodak(dot)edu> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: LIKE query running slow |
| Date: | 2003-09-24 05:20:44 |
| Message-ID: | Pine.LNX.4.44.0309240718190.352-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 23 Sep 2003, Garrett Bladow wrote:
> Recently we upgraded the RAM in our server. After the install a LIKE
> query that used to take 5 seconds now takes 5 minutes. We have tried the
> usual suspects, VACUUM, ANALYZE and Re-indexing.
If you mean that you reinstalled postgresql then it's probably because you
before run the database with the "C" locale but now you run it with
something else.
If all you did was to install the extra memory then I don't see how that
can affect it at all (especially so if you have not altered
postgresql.conf to make use of more memory).
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Bjorklund | 2003-09-24 05:24:26 | Re: restore time: sort_mem vs. checkpoing_segments |
| Previous Message | Nick Fankhauser | 2003-09-24 02:32:24 | Re: How to make n_distinct more accurate. |