Thread: 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 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, 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.