random_page_cost with a value set to "2" and it works fine
Thanks for your help
2011/3/1 Maciek Sakrejda
> On Tue, Mar 1, 2011 at 4:44 AM, Joby Joba wrote:
> > Me again ! I have checked this question of 'explain analyze' and I
> > understand now.
> >
the other trace but it doesn't
countain the information you are asking for.
So Tomas, you were right !
All apologies ! (I'm confused)
But the problem still not resolved .
2011/3/1 Joby Joba
> Sorry ! The command I use is 'EXPLAIN ANALYZE'
> I can't do be
Sorry ! The command I use is 'EXPLAIN ANALYZE'
I can't do better ...
2011/3/1
> > I've already used an 'EXPLAIN ANALYZE' to post the message. So I don't
> > clearly understand what you are expecting for, when you tell me to
> provide
> > 'EXPLAIN ANALYZE' (please excuse me for the misunderstood
I've already used an 'EXPLAIN ANALYZE' to post the message. So I don't
clearly understand what you are expecting for, when you tell me to provide
'EXPLAIN ANALYZE' (please excuse me for the misunderstood)
I agree with you when you say that for two different values, the costs will
be different. Bu
*Hi all !
Postgresql (8.2) has as a strange behaviour in some of my environments.
*
*A request follows two execution plans ( but not always !!! ). I encounter
some difficulties to reproduce the case.*
*J-2*
Aggregate (*cost=2323350.24..2323350.28 rows=1 width=24*)
-> Merge Join (cost=2214044
