SDP query optimizer

From: Adriano Lange <alange0001(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SDP query optimizer
Date: 2013-03-22 23:35:43
Message-ID: 514CEACF.1070402@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I have developed a new query optimizer for PostgreSQL and I would like
to share it with the community. The optimizer's name is Sampling and
Dynamic Programming (SDP). I put it into a plugin developed some years
ago, named LJQO:

https://github.com/alange0001/ljqo.git

This plugin was configured to compile only against PostgreSQL 9.2.
However, I guess it may be easily adjusted for other versions of PostgreSQL.

I would be glad for any feedback about SDP or even about LJQO.

I have some numbers about the SDP in comparison with GEQO. If
interested, see a diff between the two ".out2" files attached. The
schema and query are from a previous email posted by Andres Freund in
this list.

Thanks for attention.
Adriano Lange

Attachment Content-Type Size
query_2_geqo.out2 text/plain 72.9 KB
query_2_sdp_1.out2 text/plain 72.8 KB
query_2.sql text/x-sql 2.2 KB
schema.sql text/x-sql 6.3 KB
views.sql text/x-sql 55.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2013-03-23 00:22:28 Re: SDP query optimizer
Previous Message Alvaro Herrera 2013-03-22 23:12:02 Re: DROP OWNED BY fails to drop privileges granted by non-owners (was Re: [GENERAL] Bug, Feature, or what else?)