Postgres Pro
Downloads
Home   >   mailing lists

Re: sunquery and estimated rows - Mailing list pgsql-performance

From Markus Bertheau
Subject Re: sunquery and estimated rows
Date
Msg-id 1082316145.2191.0.camel@yarrow.bertheau.de
Whole thread Raw
In response to Re: sunquery and estimated rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: sunquery and estimated rows
Re: sunquery and estimated rows
List pgsql-performance
Tree view 
В Сбт, 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>

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Toooo many context switches (maybe SLES8?)
Next
From: Tom Lane
Date:
Subject: Re: Wierd context-switching issue on Xeon