Skip site navigation (1) Skip section navigation (2)

Re: Force another plan.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fredrik Olsson <fredrik(dot)olsson(at)treyst(dot)se>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Force another plan.
Date: 2006-02-18 18:36:51
Message-ID: 20490.1140287811@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Fredrik Olsson <fredrik(dot)olsson(at)treyst(dot)se> writes:
> I have some quite huge queries, inside functions, so debugging is kind 
> of hard. But I have located the query that for some reason gets 4 times 
> as slow after an analyze.

Could we see EXPLAIN ANALYZE output for these cases, not just EXPLAIN?
It seems a bit premature to be discussing ways to "force" a plan choice
when you don't even have a clear idea what's going wrong.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Fredrik OlssonDate: 2006-02-19 12:38:58
Subject: Re: Force another plan.
Previous:From: RonDate: 2006-02-18 17:01:10
Subject: Re: qsort again (was Re: [PERFORM] Strange Create

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group