Re: sunquery and estimated rows

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Litao Wu <litaowu(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: sunquery and estimated rows
Date: 2004-04-18 19:22:26
Message-ID: 1082316145.2191.0.camel@yarrow.bertheau.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-04-18 21:47:41 Re: Wierd context-switching issue on Xeon
Previous Message Dave Cramer 2004-04-18 18:49:53 Re: Toooo many context switches (maybe SLES8?)