On Mon, Oct 31, 2011 at 1:50 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> If you can't do that for some reason, there's always auto_explain, but
> that has some overhead and is a bit more work to set up.
If it's a massive load of data with a lot of queries, I think his best
bet is to log the queries with log_min_duration_statement = <something
sensible> (I'd try to start with 30ms) then analyze the log results
with pgFouine or any other log analyzer for both versions.
In response to
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2011-10-31 16:13:40|
|Subject: Re: BUG #6278: Index scans on '>' condition on field with many NULLS|
|Previous:||From: Tom Lane||Date: 2011-10-31 14:37:38|
|Subject: Re: BUG #6278: Index scans on '>' condition on field with many NULLS |