Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group