[Pkg-postgresql-private] Re: Bug#234017: postgresql: Please chattr +A the wal-directory

[Martin Pitt]

Hi Oliver!

On 2004-02-24 19:29 +0000, Oliver Elphick wrote:
> On Tue, 2004-02-24 at 18:56, Oliver Elphick wrote:
> > Presumably this would have to be put in initdb, or do you envisage its
> > being added to the postinst script?  The former would be better for
> > ensuring consistency; however it would involve another change from
> > upstream behaviour, which we should be reluctant to do.
> 
> On thinking a bit more about this, I believe it would violate the
> principle of least surprise.  I expect to be able to use "ls -lu" to
> find out when a file was last accessed, and if the directory was
> chattred, it would give me misleading information and I wouldn't realise
> it.
> 
> It would also have to be repeated after every table creation, and
> whenever a table got up to the size limit and split; I don't think it is
> feasible for the package to arrange for that.
> 
> If system administrators want to do this, they should do it themselves. 
> I would favour tagging this "wontfix".

We could ask the bug reporter for concrete benchmarks (or do them on
ourselves); if it does not gain much (i. e. more than 10%, which I
doubt), I would agree to "wontfix".

Martin

-- 
Martin Pitt                 Debian GNU/Linux Developer
martin@piware.de                      mpitt@debian.org
http://www.piware.de             http://www.debian.org