chang chao writes:
> The actual rows(rows=9950) part in the following line contained in the above
> query plan seems strange.
> " -> Sort (cost=10.64..11.14 rows=200 width=520) (actual time=0.045..0.561
> rows=9950 loops=1)"
> Shouldn't it be 200?
No, that's probably correct, seeing that thi
Hi all
The test data and sql is in the following mail.
http://www.postgresql.org/message-id/sg2pr06mb114954351fa5dae7566854a984...@sg2pr06mb1149.apcprd06.prod.outlook.com
After I disabled hash join and nested-loop join(set enable_hashjoin = off; set
enable_nestloop = off;) and execute the query