Improving GEQO - Mailing list pgsql-hackers

From boix
Subject Improving GEQO
Date
Msg-id 556623C2.7080704@uclv.cu
Whole thread Raw
Responses Re: Improving GEQO  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Improving GEQO  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers

Hello, my partner and me are working with the goal of improve the GEQO's performance, we tried with Ant Colony Optimization, but it does not improve, actually we are trying with a new variant of Genetic Algorithm, specifically Micro-GA. This algorithm finds a better solution than GEQO in less time, however the total query execution time is higher. The fitness is calculated by geqo_eval function. Does anybody know why this happens?

We attach the patch made with the changes in postgresql-9.2.0.
Regards.

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Run pgindent now?
Next
From: Ted Toth
Date:
Subject: Re: rhel6 rpm file locations