Home > mailing lists

Re: Help with tuning this query (with explain analyze finally) - Mailing list pgsql-performance

From	Ken Egervari
Subject	Re: Help with tuning this query (with explain analyze finally)
Date	March 3, 2005 12:21:28
Msg-id	000a01c51fd2$64bc6a70$6a01a8c0@KEN Whole thread Raw
In response to	Help with tuning this query ("Ken Egervari" <ken@upfactor.com>)
List	pgsql-performance

>2) Force PG to drop the merge join via SET ENABLE_MERGEJOIN = FALSE;

Actually, it was 312 milliseconds, so it got worse.

From: Richard Huxton
Date: 03 March 2005, 10:06:56
Subject: Re: Help with tuning this query (more musings)

From: Jeremiah Jahn
Date: 03 March 2005, 19:38:41
Subject: name search query speed