Re: SDP query optimizer - Mailing list pgsql-hackers

From Adriano Lange
Subject Re: SDP query optimizer
Date
Msg-id 514DEB96.1010806@gmail.com
Whole thread Raw
In response to Re: SDP query optimizer  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 23-03-2013 10:15, Andres Freund wrote:
> I just want to mention that unless you skew the statistics for the individual
> tables from their empty/default state this mostly measures a pretty degenerate
> case where optima are very rare and not very differentiated. Thats a useful
> thing to test, but not to have as the target to optimize for.
> So it might be interesting to run that thing with some table
> stats/contents stats set up.


Yes, the search space obtained from this experiment may be very simpler 
than a real case. Beyond this experiment, I can construct classical 
queries used to evaluate this kind of algorithm, as stars, cliques, 
chains and cycles. Beyond these queries I have no idea how can I further 
test it.

Regards,

Adriano Lange



pgsql-hackers by date:

Previous
From: Nicholas White
Date:
Subject: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls
Next
From: Tom Lane
Date:
Subject: Re: Request for Patch Feedback: Lag & Lead Window Functions Can Ignore Nulls