Re: LIKE query running slow

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: bbladow(at)sendit(dot)nodak(dot)edu
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: LIKE query running slow
Date: 2003-09-24 00:53:57
Message-ID: 1064364837.18409.31.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 2003-09-23 at 20:24, 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.
>
> Any thoughts on what might have happened?

What settings did you change at that time?

Care to share an EXPLAIN ANALYZE with us?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Nick Fankhauser 2003-09-24 02:32:24 Re: How to make n_distinct more accurate.
Previous Message Garrett Bladow 2003-09-24 00:41:13 Re: LIKE query running slow