Re: [ADMIN] query from 9.0 fails to return on 9.2

2012-10-15 Thread Bill MacArthur
On 10/12/2012 4:27 PM, Tom Lane wrote: Bill MacArthur writes: Here is the top line of the *really long* explain as run on a 9.0 server (it takes only a couple of seconds to return): HashAggregate (cost=1148.97..1149.36 rows=1 width=205) However, the same query run on the same machine after u

Re: [ADMIN] query from 9.0 fails to return on 9.2

2012-10-12 Thread Tom Lane
Bill MacArthur writes: > Here is the top line of the *really long* explain as run on a 9.0 server (it > takes only a couple of seconds to return): HashAggregate > (cost=1148.97..1149.36 rows=1 width=205) > However, the same query run on the same machine after upgrade to 9.2.1 never > returns.

[ADMIN] query from 9.0 fails to return on 9.2

2012-10-12 Thread Bill MacArthur
I value the work of the community and in particular the dedicated committers on the postgres team, regardless of this little wrinkle we have encountered upon our transition from 9.0 to 9.2. Since the number of tables involved is ridiculously small and the amount of data is negligible, at this p