Re: [HACKERS] SDP query optimizer

2013-03-23 Thread Adriano Lange
, but it was inactive. Therefore, I decided to start a new one. [1] - http://pgfoundry.org/projects/optimizer/ Anyway, good work for all of you. -- Adriano Lange -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] SDP query optimizer

2013-03-23 Thread Adriano Lange
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] TwoPO: experimental join order algorithm

2010-08-05 Thread Adriano Lange
On Fri, Jul 30, 2010 at 7:02 AM, Jan Urbański wulc...@wulczer.org wrote: On 24/07/10 15:20, Adriano Lange wrote: Hi, Hi! I'd like to release the last version of my experimental join order algorithm (TwoPO - Two Phase Optimization [1]): http://git.c3sl.ufpr.br/gitweb?p=lbd/ljqo.git

Re: [HACKERS] TwoPO: experimental join order algorithm

2010-07-25 Thread Adriano Lange
Em 25-07-2010 17:44, Robert Haas escreveu: On Sat, Jul 24, 2010 at 9:20 AM, Adriano Lange alange0...@gmail.com wrote: I'd like to release the last version of my experimental join order algorithm (TwoPO - Two Phase Optimization [1]): http://git.c3sl.ufpr.br/gitweb?p=lbd/ljqo.git;a=summary

Re: [HACKERS] TwoPO: experimental join order algorithm

2010-07-25 Thread Adriano Lange
Em 25-07-2010 19:17, Robert Haas escreveu: On Sun, Jul 25, 2010 at 6:45 PM, Adriano Lange alange0...@gmail.com wrote: Yes, I know. This is only a notice, not a patch. As I said, this algorithm is experimental, which do not match with the CommitFest life cycle. It matches just fine - you

[HACKERS] TwoPO: experimental join order algorithm

2010-07-24 Thread Adriano Lange
Engineering and Applications Symposium, pages 296-302, Washington, DC, USA, 2007. IEEE Computer Society. [4] Florian Waas e Arjan Pellenkoft. Join order selection - good enough is easy. BNCOD, pages 51-67, 2000. Att, Adriano Lange -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] join ordering via Simulated Annealing

2009-12-23 Thread Adriano Lange
?doid=1559845.1559889 Att Adriano Lange -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Memory context usage

2009-08-29 Thread Adriano Lange
Tom Lane escreveu: Adriano Lange alange0...@gmail.com writes: I need to control the size of a memory context on the fly and take some actions when the used memory exceeds a defined size. The existing places that do that sort of thing do their own counting of how much they've allocated. I

Re: [HACKERS] Memory context usage

2009-08-28 Thread Adriano Lange
On Fri, Aug 28, 2009 at 5:18 AM, Greg Smithgsm...@gregsmith.com wrote: On Fri, 28 Aug 2009, Tom Lane wrote: MemoryContextStats() might help.  It just dumps the info to stderr though. Which means it ends up in the database log files in the common configuration where where the database's

[HACKERS] Memory context usage

2009-08-27 Thread Adriano Lange
Hi, How can I get the used memory of a memory context? Is there some function like: int getMemoryUsage( MemoryContext ) ? I still working in a subplan cache for a query optimizer and I need to know whether a temporary memory context is in certain limits. Thanks Adriano -- Sent via

Re: [HACKERS] GEQO: ERX

2009-05-20 Thread Adriano Lange
Hi Tobias Zahn escreveu: Hello Adriano, thank you very much for posting your patch. I think it will help to make further work easier, too. I hope you don't mind when I ask you some questions. When you said that this new approach is worse or equal than GEQO, did you refer to performance or to

Re: [HACKERS] GEQO: ERX

2009-05-19 Thread Adriano Lange
reading more about the compressed annealing, cited in TODO list. Anyway, I think that to build another annealing-like algorithm might be easier if some structures and functions in 2PO source code are correct. Sincerely, Adriano Lange -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] GEQO: ERX

2009-05-19 Thread Adriano Lange
Adriano Lange escreveu: I implemented the 2PO algorithm last month but I didn't have much time to do an extensive test and to comment all code. The code was posted in this list in a previous thread. In that occasion, I was interested in a kind of cache structure to avoid the constructing

[HACKERS] RelOptInfo cache

2009-04-21 Thread Adriano Lange
this lack of optimization. I remember that the geqo used a memory context switch for each plan evaluation. The source code of 2PO (twopo) is attached for any test. (Sorry by any (many) grammatical mistake) --- Adriano Lange /* * twopo.c *Two Phase Optimization * * Portions Copyright (c

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-19 Thread Adriano Lange
and navigability in the graph. I think that a good solution for this would be a dynamic navigability in their nodes and a rearrange their positions by focused node. I'm not remembering now, but I've saw a tool like this. Thanks -- Adriano Lange C3SL/UFPR - www.c3sl.ufpr.br -- Sent via pgsql-hackers

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Adriano Lange
Tom Lane escreveu: Gregory Stark st...@enterprisedb.com writes: Adriano Lange adri...@c3sl.ufpr.br writes: I've changed the debug functions of allpaths.c to make a graphviz-like output of RelOptInfo structure. However I have to say this graph you've generated is amazingly hard to decipher

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Adriano Lange
the pathkeys. Several attributes and objects are missing yet, but I will add them. Thanks, Adriano Lange C3SL/UFPR - www.c3sl.ufpr.br RelOptInfo_graph.dot Description: application/crossover-dot -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

[HACKERS] GEQO Publications

2008-07-07 Thread Adriano Lange
Hi all, I'm looking for materials explaining GEQO module. I've found something related in http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg40584.html and PostgreSQL's documentation. Nevertheless, is there some other cientific publication about it? I've tried also send email to