Re: [pgadmin-hackers] zweidimensionale Statistiken in Postgres

2014-11-05 Thread Katharina Büchse

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/



--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers


Re: [pgadmin-hackers] zweidimensionale Statistiken in Postgres

2014-11-05 Thread Guillaume Lelarge
Hi,

I'm not sure why you thought a mailing list on an admin tool would be a
better fit, but it definitely is not. Don't worry, this isn't a big issue
:-)

Anyway, pgsql-hackers is the list you're looking for.

On the patch you'd like to work on, I'd advise you someone else is working
on this. You should read the WIP: multivariate statistics / proof of
concept thread on the hackers list. I'm pretty sure you could get some
help from Tomas.

Patches on this topic are of high interest. If I can be of any help, let me
know.

Regards.
Le 5 nov. 2014 18:03, Katharina Büchse katharina.buec...@uni-jena.de a
écrit :

 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/



 --
 Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgadmin-hackers