Horton

Re: sunquery and estimated rows

Markus Bertheau <twanger@bluetwanger.de>

View thread View on postgr.es
From: Markus Bertheau <twanger@bluetwanger.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Litao Wu <litaowu@yahoo.com>, pgsql-performance@postgresql.org
Date: 2004-04-18T19:22:26Z
Lists: pgsql-performance 
В Сбт, 17.04.2004, в 01:45, Tom Lane пишет:

> The planner sees that as "where scope = <some complicated expression>"
> and falls back to a default estimate.  It won't simplify a sub-select
> to a constant.  (Some people consider that a feature ;-).)

Why?

Thanks

-- 
Markus Bertheau <twanger@bluetwanger.de>