Thanks Tom,
I do have a self-contained test case which duplicates the problem. However,
since there are data to be attached and there wasn't a way to attach in the
bug reporting form, I wasn't sure how to proceed.
Would appreciate your assistance.
Thanks again.
On Wed, Sep 26, 2012 at 11:13 PM, T
1 |
| 2056 | 3894 | 1 |
| 2056 | 3895 | 1 |
+++-+
(6 rows)
Time: 14.273 ms
On Thu, Sep 27, 2012 at 5:13 AM, Tom Lane wrote:
> Melese Tesfaye writes:
> > [ test case ]
>
> Argh. The problem query has a plan like this:
>
> ->
Thanks Pavel,
Setting enable_hashagg to off didn't resolve the issue.
Please find the explain as well as query results after "set
enable_hashagg=off;"
mtesfaye@[local](test_db)=# EXPLAIN SELECT DISTINCT(A.*)
test_db-# FROM table1_t A LEFT JOIN table2_v B
test_db-# ON A.pnr_id=B.pnr_id
test_db-# WH
