[postgis-users] Odd explain analyze estimates?

[strk at refractions.net]

Mark, read carefully the explain analyze outputs.
It seems normal to me that using subqueries doesn't allow the
optimizer to take good decisions, while the query with no subquery
has *excellent* estimates, am I reading something wrong ?

I don't think disabling the JOINSEL will do any better...
Anyway we should wait for next report.

--strk;

On Fri, Mar 04, 2005 at 05:10:21PM -0000, Mark Cave-Ayland wrote:
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net 
> > [mailto:postgis-users-bounces at postgis.refractions.net] On 
> > Behalf Of strk at refractions.net
> > Sent: 04 March 2005 16:59
> > To: 'PostGIS Users Discussion'
> > Subject: Re: [postgis-users] Odd explain analyze estimates?
> 
> (cut)
> 
> > It makes our JOINSEL return a default value:
> > #define DEFAULT_GEOMETRY_JOINSEL 0.000005
> > 
> > If I recall correctly the pgsql default was much higher (0.1 
> > or something).
> > 
> > --strk;
> 
> 
> Ah yes, I remember now :)
> 
> I'm tempted to suggest using the old method for RC4 until I can devise
> something better...
> 
> 
> Kind regards,
> 
> Mark.
> 
> ------------------------
> WebBased Ltd
> South West Technology Centre
> Tamar Science Park
> Plymouth
> PL6 8BT 
> 
> T: +44 (0)1752 791021
> F: +44 (0)1752 791023
> W: http://www.webbased.co.uk
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users