Re: [PERFORM] Different execution plan

2008-09-24 Thread Matthew Wakeling
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 p

Re: [PERFORM] Different execution plan

2008-09-24 Thread Sabin Coanda
I use postgresql-8.2-506.jdbc3.jar, maybe helps Sabin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Different execution plan

2008-09-24 Thread Sabin Coanda
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 -- Sent via pgsql-performance maili

Re: [PERFORM] Different execution plan

2008-09-22 Thread Sabin Coanda
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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes

Re: [PERFORM] Different execution plan

2008-09-22 Thread Scott Marlowe
On Mon, Sep 22, 2008 at 2:40 PM, Sabin Coanda <[EMAIL PROTECTED]> 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 p