Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/algebra algopt.c, Feb2009, 1.46.2.4, 1.46.2.5
On Fri, Mar 20, 2009 at 09:58:04AM +0000, Bastian Brodbeck wrote:
Update of /cvsroot/monetdb/pathfinder/compiler/algebra In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13909/compiler/algebra
Modified Files: Tag: Feb2009 ^^^^^^^ algopt.c Log Message: adding new optimization -Y ^^^^^^^^^^^^^^^^^^^^^^^^^^ is this a bug fix or a new feature?
If the latter (as I suspect), please undo this checking on the Feb2009 branch and redo it on the development trunk (HEAD), using only CVS commands, as, e.g., discribed on page 15 of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf (pages 8 - 16 might be interesting) Thanks! Stefan
this optimization pushes projection up in the tree to minimize them. the goal is to simplify the tree for other optimizations
U algopt.c Index: algopt.c =================================================================== RCS file: /cvsroot/monetdb/pathfinder/compiler/algebra/algopt.c,v retrieving revision 1.46.2.4 retrieving revision 1.46.2.5 diff -u -d -r1.46.2.4 -r1.46.2.5 --- algopt.c 6 Feb 2009 14:48:45 -0000 1.46.2.4 +++ algopt.c 20 Mar 2009 09:58:02 -0000 1.46.2.5 @@ -179,6 +179,19 @@ PFlog (" MonetDB specific optimizations: %s", PFtimer_str (tm)); break; + + case 'Y': + /*REMOVE_PROXIES("MonetDB specific optimization")*/ + + tm = PFtimer_start (); + + root = PFalgopt_projection (root); + + tm = PFtimer_stop (tm); + if (timing) + PFlog (" project optimizations: %s", + PFtimer_str (tm)); + break;
case 'E': MAP_UNQ_NAMES("common subexpression elimination")
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-pf-checkins mailing list Monetdb-pf-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
sorry, moved all files. and thx for the pdf. Bastian Am 20.03.2009 um 11:08 schrieb Stefan Manegold:
On Fri, Mar 20, 2009 at 09:58:04AM +0000, Bastian Brodbeck wrote:
Update of /cvsroot/monetdb/pathfinder/compiler/algebra In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13909/ compiler/algebra
Modified Files: Tag: Feb2009 ^^^^^^^ algopt.c Log Message: adding new optimization -Y ^^^^^^^^^^^^^^^^^^^^^^^^^^ is this a bug fix or a new feature?
If the latter (as I suspect), please undo this checking on the Feb2009 branch and redo it on the development trunk (HEAD), using only CVS commands, as, e.g., discribed on page 15 of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf (pages 8 - 16 might be interesting)
Thanks!
Stefan
this optimization pushes projection up in the tree to minimize them. the goal is to simplify the tree for other optimizations
U algopt.c Index: algopt.c =================================================================== RCS file: /cvsroot/monetdb/pathfinder/compiler/algebra/algopt.c,v retrieving revision 1.46.2.4 retrieving revision 1.46.2.5 diff -u -d -r1.46.2.4 -r1.46.2.5 --- algopt.c 6 Feb 2009 14:48:45 -0000 1.46.2.4 +++ algopt.c 20 Mar 2009 09:58:02 -0000 1.46.2.5 @@ -179,6 +179,19 @@ PFlog (" MonetDB specific optimizations: %s", PFtimer_str (tm)); break; + + case 'Y': + /*REMOVE_PROXIES("MonetDB specific optimization")*/ + + tm = PFtimer_start (); + + root = PFalgopt_projection (root); + + tm = PFtimer_stop (tm); + if (timing) + PFlog (" project optimizations: %s", + PFtimer_str (tm)); + break;
case 'E': MAP_UNQ_NAMES("common subexpression elimination")
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-pf-checkins mailing list Monetdb-pf-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
No problem. Thansk for the quick fix! Stefan On Fri, Mar 20, 2009 at 01:42:47PM +0100, Bastian Brodbeck wrote:
sorry, moved all files. and thx for the pdf.
Bastian
Am 20.03.2009 um 11:08 schrieb Stefan Manegold:
On Fri, Mar 20, 2009 at 09:58:04AM +0000, Bastian Brodbeck wrote:
Update of /cvsroot/monetdb/pathfinder/compiler/algebra In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13909/ compiler/algebra
Modified Files: Tag: Feb2009 ^^^^^^^ algopt.c Log Message: adding new optimization -Y ^^^^^^^^^^^^^^^^^^^^^^^^^^ is this a bug fix or a new feature?
If the latter (as I suspect), please undo this checking on the Feb2009 branch and redo it on the development trunk (HEAD), using only CVS commands, as, e.g., discribed on page 15 of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf (pages 8 - 16 might be interesting)
Thanks!
Stefan
this optimization pushes projection up in the tree to minimize them. the goal is to simplify the tree for other optimizations
U algopt.c Index: algopt.c =================================================================== RCS file: /cvsroot/monetdb/pathfinder/compiler/algebra/algopt.c,v retrieving revision 1.46.2.4 retrieving revision 1.46.2.5 diff -u -d -r1.46.2.4 -r1.46.2.5 --- algopt.c 6 Feb 2009 14:48:45 -0000 1.46.2.4 +++ algopt.c 20 Mar 2009 09:58:02 -0000 1.46.2.5 @@ -179,6 +179,19 @@ PFlog (" MonetDB specific optimizations: %s", PFtimer_str (tm)); break; + + case 'Y': + /*REMOVE_PROXIES("MonetDB specific optimization")*/ + + tm = PFtimer_start (); + + root = PFalgopt_projection (root); + + tm = PFtimer_stop (tm); + if (timing) + PFlog (" project optimizations: %s", + PFtimer_str (tm)); + break;
case 'E': MAP_UNQ_NAMES("common subexpression elimination")
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-pf-checkins mailing list Monetdb-pf-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
participants (2)
-
Bastian Brodbeck -
Stefan Manegold