Fernando, > We have a server side GUI utility that among other things let us configure GUC > variables. We badly need to know what variables exist in the specific backend > version, which are the min and max values and if possible a description. The > option is to hardwire these things into the code which is very awkward (and we > want it to work with different backend versions, backends compiled differently > etc.).
As the new "GUC List" guru, I will send you a list in PDF or SXW format which covers 7.3 and 7.4 this weekend. If you database it, I would love to have the table back in return. Please note that the actual maximum value for many variables is much larger than the practical maximum value. For example, RANDOM_PAGE_COST is only limited to INT MAX on the host OS, even though all practical values are between 1 and 10. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match