Re: Help with tuning this query (with explain analyze finally)

From: "Ken Egervari" <ken(at)upfactor(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help with tuning this query (with explain analyze finally)
Date: 2005-03-03 09:21:33
Message-ID: 000a01c51fd2$64bc6a70$6a01a8c0@KEN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-performance

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

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

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Josh Berkus 2005-03-03 17:35:14 Re: Help with tuning this query (with explain analyze finally)
Previous Message Richard Huxton 2005-03-03 07:06:47 Re: Help with tuning this query (more musings)

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremiah Jahn 2005-03-03 16:38:29 name search query speed
Previous Message Richard Huxton 2005-03-03 07:06:47 Re: Help with tuning this query (more musings)