GUC configuration
Hi,
I am an MSc student in the department of Informatics and
Telecommunications of the University of Athens and as part of my
thesis I am examining some new cost models for DB optimizers. I have
successfully changed the optimizer of PostgreSQL in order to implement
these models, but I have stumbled upon a very little detail: until now
I use some hardcoded values in my code which I would like to make
accessible through GUC. After much googling the only relative pages I
have found is about configuring existing PostgreSQL variables. Can
anybody please provide some help? How can I add some new configuration
variables using GUC?
Thanks in advance,
Thanos Papapetrou
Θάνος Παπαπέτρου
You insist that there is something that a machine can't do. If you
will tell me precisely what it is that a machine cannot do, then I can
always make a machine which will do just that.
On %D, %SN wrote:
%Q
%C
--
Robert...
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
owner@postgresql.org] On Behalf Of T???? ?apap?t???
Sent: Thursday, February 10, 2011 2:18 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] GUC configurationHi,
I am an MSc student in the department of Informatics and
Telecommunications of the University of Athens and as part of my
thesis I am examining some new cost models for DB optimizers. I have
successfully changed the optimizer of PostgreSQL in order to implement
these models, but I have stumbled upon a very little detail: until now
I use some hardcoded values in my code which I would like to make
accessible through GUC. After much googling the only relative pages I
have found is about configuring existing PostgreSQL variables. Can
anybody please provide some help? How can I add some new configuration
variables using GUC?Thanks in advance,
Are you looking for custom variable classes?
http://www.postgresql.org/docs/8.4/interactive/runtime-config-custom.htm
l
--
Robert...
On 10 Φεβ 2011, at 7:45 ΜΜ, Wappler, Robert wrote:
Are you looking for custom variable classes?
http://www.postgresql.org/docs/8.4/interactive/runtime-config-custom.htm
No, thanks for the interest though. I am not developing an add-on in
order to use such kind of functionality. I have made extensive
modifications to the internals of the PostgreSQL optimizer and I need
to have some extra configuration variables passed to it, so I want to
extend the set of core configuration variables and not add some
"external" ones for an add-on module.
Eventually I posted my question in hackers mailing list and I have
found the answers I need - I have to programmatically modify GUC
itself too.
Thanks again,
Thanos
Θάνος Παπαπέτρου
You insist that there is something that a machine can't do. If you
will tell me precisely what it is that a machine cannot do, then I can
always make a machine which will do just that.