pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedLIKE 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