pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Different execution plan
5+ messages / 3 participants
[nested] [flat]
* Re: Different execution plan
@ 2008-09-22 20:40 Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-22 21:19 ` Re: Different execution plan Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Sabin Coanda @ 2008-09-22 20:40 UTC (permalink / raw)
To: pgsql-performance
Hi there,
I am still concerned about this problem, because there is a big differences
between the two cases, and I don't know how to identify the problem. Can
anybody help me, please ?
TIA,
Sabin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Different execution plan
2008-09-22 20:40 Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
@ 2008-09-22 21:19 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-24 07:42 ` Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-24 09:57 ` Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
0 siblings, 2 replies; 5+ messages in thread
From: Scott Marlowe @ 2008-09-22 21:19 UTC (permalink / raw)
To: Sabin Coanda <sabin.coanda@deuromedia.ro>; +Cc: pgsql-performance
On Mon, Sep 22, 2008 at 2:40 PM, Sabin Coanda
<sabin.coanda@deuromedia.ro> wrote:
> Hi there,
>
> I am still concerned about this problem, because there is a big differences
> between the two cases, and I don't know how to identify the problem. Can
> anybody help me, please ?
Sure, first step, if you can provide the following:
pg version
os and version
output of explain analyze of each query (one good query, one bad)
In the meantime, make sure you've vacuum analyzed your db.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Different execution plan
2008-09-22 20:40 Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-22 21:19 ` Re: Different execution plan Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-09-24 07:42 ` Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-24 11:06 ` Re: Different execution plan Matthew Wakeling <matthew@flymine.org>
1 sibling, 1 reply; 5+ messages in thread
From: Sabin Coanda @ 2008-09-24 07:42 UTC (permalink / raw)
To: pgsql-performance
Hi Scott,
I think it would be nice to log the reasons why an explain analyze chooses a
specific way or another for an execution plan. This would avoid wasting time
to find the source of these decisions from the existing logs.
Is it possible ?
TIA,
Sabin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Different execution plan
2008-09-22 20:40 Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-22 21:19 ` Re: Different execution plan Scott Marlowe <scott.marlowe@gmail.com>
2008-09-24 07:42 ` Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
@ 2008-09-24 11:06 ` Matthew Wakeling <matthew@flymine.org>
0 siblings, 0 replies; 5+ messages in thread
From: Matthew Wakeling @ 2008-09-24 11:06 UTC (permalink / raw)
To: pgsql-performance
On Wed, 24 Sep 2008, Sabin Coanda wrote:
> I think it would be nice to log the reasons why an explain analyze chooses a
> specific way or another for an execution plan. This would avoid wasting time
> to find the source of these decisions from the existing logs.
That would probably fill up the logs pretty quickly.
What may be really useful would be some sort of "extended explain" option.
At the moment, explain prints out the best query plan found. Sometimes it
would be nice if it printed out all the plans it considered, so we don't
have to go fiddling with enable_xxx to find alternatives.
Matthew
--
I suppose some of you have done a Continuous Maths course. Yes? Continuous
Maths? <menacing stares from audience> Whoah, it was like that, was it!
-- Computer Science Lecturer
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Different execution plan
2008-09-22 20:40 Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-22 21:19 ` Re: Different execution plan Scott Marlowe <scott.marlowe@gmail.com>
@ 2008-09-24 09:57 ` Sabin Coanda <sabin.coanda@deuromedia.ro>
1 sibling, 0 replies; 5+ messages in thread
From: Sabin Coanda @ 2008-09-24 09:57 UTC (permalink / raw)
To: pgsql-performance
I use postgresql-8.2-506.jdbc3.jar, maybe helps
Sabin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-09-24 11:06 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-22 20:40 Re: Different execution plan Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-22 21:19 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-24 07:42 ` Sabin Coanda <sabin.coanda@deuromedia.ro>
2008-09-24 11:06 ` Matthew Wakeling <matthew@flymine.org>
2008-09-24 09:57 ` Sabin Coanda <sabin.coanda@deuromedia.ro>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox