pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
LIKE query running slow
7+ messages / 7 participants
[nested] [flat]

* LIKE query running slow
@ 2003-09-24 00:24  Garrett Bladow <bbladow@sendit.nodak.edu>
  0 siblings, 5 replies; 7+ messages in thread

From: Garrett Bladow @ 2003-09-24 00:24 UTC (permalink / raw)
  To: pgsql-performance

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?

-Garrett Bladow




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: LIKE query running slow
@ 2003-09-24 00:35  Josh Berkus <josh@agliodbs.com>
  parent: Garrett Bladow <bbladow@sendit.nodak.edu>
  4 siblings, 1 reply; 7+ messages in thread

From: Josh Berkus @ 2003-09-24 00:35 UTC (permalink / raw)
  To: bbladow@sendit.nodak.edu; 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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: LIKE query running slow
@ 2003-09-24 00:41  Garrett Bladow <bladow@rocko.cc.ndsu.nodak.edu>
  parent: Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 7+ messages in thread

From: Garrett Bladow @ 2003-09-24 00:41 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance

On Tue, 23 Sep 2003, Josh Berkus wrote:

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

RAM was tested and is good.




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: LIKE query running slow
@ 2003-09-24 00:53  Rod Taylor <rbt@rbt.ca>
  parent: Garrett Bladow <bbladow@sendit.nodak.edu>
  4 siblings, 0 replies; 7+ messages in thread

From: Rod Taylor @ 2003-09-24 00:53 UTC (permalink / raw)
  To: bbladow@sendit.nodak.edu; +Cc: 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?

Attachments:

  signature.asc (application/pgp-signature, 186B) download

^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: LIKE query running slow
@ 2003-09-24 05:20  Dennis Bjorklund <db@zigo.dhs.org>
  parent: Garrett Bladow <bbladow@sendit.nodak.edu>
  4 siblings, 0 replies; 7+ messages in thread

From: Dennis Bjorklund @ 2003-09-24 05:20 UTC (permalink / raw)
  To: Garrett Bladow <bbladow@sendit.nodak.edu>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: LIKE query running slow
@ 2003-09-24 06:06  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  parent: Garrett Bladow <bbladow@sendit.nodak.edu>
  4 siblings, 0 replies; 7+ messages in thread

From: Shridhar Daithankar @ 2003-09-24 06:06 UTC (permalink / raw)
  To: bbladow@sendit.nodak.edu; +Cc: 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




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: LIKE query running slow
@ 2003-09-24 12:12  Jeff <threshar@torgo.978.org>
  parent: Garrett Bladow <bbladow@sendit.nodak.edu>
  4 siblings, 0 replies; 7+ messages in thread

From: Jeff @ 2003-09-24 12:12 UTC (permalink / raw)
  To: Garrett Bladow <bbladow@sendit.nodak.edu>; +Cc: 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.
>
> Any thoughts on what might have happened?
>
Did you reload the db? If you did perhaps you didn't use the "C" locale?
That can cause a huge slowdown.


--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/





^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2003-09-24 12:12 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-24 00:24 LIKE query running slow Garrett Bladow <bbladow@sendit.nodak.edu>
2003-09-24 00:35 ` Josh Berkus <josh@agliodbs.com>
2003-09-24 00:41   ` Garrett Bladow <bladow@rocko.cc.ndsu.nodak.edu>
2003-09-24 00:53 ` Rod Taylor <rbt@rbt.ca>
2003-09-24 05:20 ` Dennis Bjorklund <db@zigo.dhs.org>
2003-09-24 06:06 ` Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
2003-09-24 12:12 ` Jeff <threshar@torgo.978.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox