Re: Configurator project launched - Mailing list pgsql-performance

From Greg Sabino Mullane
Subject Re: Configurator project launched
Date
Msg-id 17c492d2af42972995595f73c426f2aa@biglumber.com
Whole thread Raw
In response to Re: Configurator project launched  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Configurator project launched  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


>> Um, can't we just get that from pg_settings?
>>
>> Anyway, I'll be deriving settings from the .conf file, since most of the
>> time the Configurator will be run on a new installation.
>
> Aren't most of the settings all kept in the SHOW variables anyway?

As I said, it may not be applicable to this project, but thought I would
offer. One gotcha the module makes transparent is that in older versions of
PG, the variables are returned in a different way (via RAISE). My module
will allow you to get the configuration for any connected database, for
any configuration file, and the defaults for any known version, and do
quick comparisons between them all. So you could use it to see what has
changed between a particular server and its conf file, or the differences
between two conf files, or the differences between two databases, or even show
what has changed in the default conf file from 7.4.7 and 8.0.1. It will also
allow you to rewrite the conf files in a standard way.

I'm hoping to roll this into 1.44 or 1.45 or DBD::Pg.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200506212046
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCuLWDvJuQZxSWSsgRAjUVAJ42oeveZBuutFo1G3Cs/3dRZWjKggCfS1Yf
Tv5RWiG9s8Ucv/t/2HZ4/R8=
=1eap
-----END PGP SIGNATURE-----



pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Configurator project launched
Next
From: Tobias Brox
Date:
Subject: Re: Limit clause not using index