Home > mailing lists

LIKE query running slow - Mailing list pgsql-performance

From	Garrett Bladow
Subject	LIKE query running slow
Date	September 24, 2003 00:28:58
Msg-id	Pine.LNX.4.44.0309231921200.17451-100000@rocko.cc.ndsu.nodak.edu Whole thread Raw
Responses	Re: LIKE query running slow Re: LIKE query running slow Re: LIKE query running slow Re: LIKE query running slow Re: LIKE query running slow
List	pgsql-performance

Tree view

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

pgsql-performance by date:

From: "Nick Fankhauser"
Date: 24 September 2003, 00:27:50
Subject: How to make n_distinct more accurate.

From: Vivek Khera
Date: 24 September 2003, 00:28:59
Subject: Re: restore time: sort_mem vs. checkpoing_segments

LIKE query running slow - Mailing list pgsql-performance

Previous

Next