Robert Treat escreveu:
On Saturday 09 August 2008 21:31:28 Euler Taveira de Oliveira wrote:
Hi,
After the Magnus patch [1], that make it possible store statistics files
at another (RAM-based) disk, I was thinking that would be useful to add
an option at initdb time to do the symlink as we already do with xlog.
Maybe it could be documented in monitoring.sgml too. Comments?
[1] http://archives.postgresql.org/pgsql-hackers/2008-08/msg00176.php
I find Magnus's approach to be admin un-friendly, and your patch a
re-enforcement of that feeling. Forcing people to fall back on the OS tools
(which may not be terribly good on systems like win32) when we could provide
a consistent way for postgres to handle this itself seems backwards. I
believe this would be much simpler for DBA's if we simply give them a GUC for
stat file location, and allow them to set the location that way. Ideally this
could be done as PGC_SIGHUP, and a change to the location would move the
file "on-the-fly" as they say. (There might be practical limitation to making
that work, but it would certainly be simpler for admins, imho)
How many times will you change the pg_stat_tmp directory? IMHO it is
something that we don't frequently change. I agree that GUC is a
DBA-friendly-option but we have to deal with (i) stop stats collector
(ii) remove the old contents? (iii) start it at another location. I'm
not saying that is _so_ difficult to do but I could live with
pg_stat_tmp symlink option.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
