Re: LIKE query running slow

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: bbladow(at)sendit(dot)nodak(dot)edu, pgsql-performance(at)postgresql(dot)org
Subject: Re: LIKE query running slow
Date: 2003-09-24 00:35:50
Message-ID: 200309231735.50719.josh@agliodbs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Garrett,

> 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?

Bad RAM? Have you tested it?

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Garrett Bladow 2003-09-24 00:41:13 Re: LIKE query running slow
Previous Message Garrett Bladow 2003-09-24 00:24:26 LIKE query running slow