Re: LIKE query running slow

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: bbladow(at)sendit(dot)nodak(dot)edu
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: LIKE query running slow
Date: 2003-09-24 06:06:02
Message-ID: 3F71344A.4090605@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 all tuning you have done? Have you set effective cache size to take care of
additional RAM.

Just check out.

Shridhar

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2003-09-24 09:14:19 Re: osdl-dbt3 run results - puzzled by the execution
Previous Message peter 2003-09-24 05:48:15 Performance issue