Re: zweidimensionale Statistiken in Postgres

From: Katharina Büchse <katharina(dot)buechse(at)uni-jena(dot)de>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: zweidimensionale Statistiken in Postgres
Date: 2014-11-05 17:03:17
Message-ID: 545A5855.8080501@uni-jena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

I was unsure to which mailing list to write, in my opinion psql-hackers
would fit best, but as it is not recommended to write there directly,
I'm trying here.
I'm a phd-student at the university of Jena, Thüringen, Germany, in the
field of data bases, more accurate query optimization.
I want to implement a system in PostgreSQL that detects column
correlations and creates statistical data about correlated columns for
the optimizer. Therefore I need to store two dimensional statistics
(especially two dimensional histograms) in PostgreSQL. I would like to
know where I have to "touch" the source code and make changes, so that
the PostgreSQL optimizer will also take into consideration my
statistical data? I also need a possibility to extract data from query
results (tuple counts and, speaking a little inaccurately, the
where-part of the query itself). Of course I tried to have a look at the
PostgreSQL source code, but it's impossible to understand everything
within a few weeks or even months....

I'd be grateful for any advices.
Regards,

Katharina

--
Dipl.-Math. Katharina Büchse
Friedrich-Schiller-Universität Jena
Institut für Informatik
Lehrstuhl für Datenbanken und Informationssysteme
Ernst-Abbe-Platz 2
07743 Jena
Telefon 03641/946367
Webseite http://users.minet.uni-jena.de/~re89qen/

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2014-11-05 17:22:22 Re: zweidimensionale Statistiken in Postgres
Previous Message J.F. Oster 2014-11-05 14:25:10 PATCH: Add missing nodes to graphical explain plan