On Apr 30, 2004, at 3:01 AM, Gary Doades wrote:
[ pg query plan, etc ]
I wonder if other parts of the plan are affecting the speed.
I've recently run into a case where a merge join plan was chosen for
this query, which took 11 seconds to execute. Forcing it to pick a
nested loop join dropped it to 3. (Updating my
default_statistics_target to 500 caused the planner to choose nested
So, is the plan really the same?
A better comparision query may be a simple "select a from mytable
where a between foo and bar" to get an index scan. In that case its a
straight up, vanilla index scan. Nothing else getting in the way.
Jeff Trout <jeff(at)jefftrout(dot)com>
In response to
pgsql-performance by date
|Next:||From: Pailloncy Jean-Gérard||Date: 2004-04-30 12:45:55|
|Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!|
|Previous:||From: Manfred Koizar||Date: 2004-04-30 07:33:13|
|Subject: Re: analyzer/planner and clustered rows|