Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
> Below are the plans for two cases. I dont know how to read them accurately
> can u please explain them.
Well, they're the same plan, as far as they go. I suppose that the
runtime difference must come from choosing a different plan inside the
most_recent_edition() function, which we cannot see in the explain
output. As before, turning on logging of verbose query plans is the
only way to look at what the function is doing.
> Also can anyone point to some documentation
> oriented towards understanding explain analyze output?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Christopher Browne||Date: 2003-07-31 05:39:44|
|Subject: Possible problem with DOMAIN evaluation?|
|Previous:||From: Bruce Momjian||Date: 2003-07-30 22:12:53|
|Subject: Re: Mapping a database completly into Memory|