From: Scott Marlowe <scott.marlowe@gmail.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Guillaume Cottenceau <gc@mnc.ch>
Cc: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: which ext3 fs type should I use for postgresql
Date: Fri, 16 May 2008 11:07:17 -0600
Message-ID: <dcc563d10805161007h5fd1c700ieb185a7979681e49@mail.gmail.com> (raw)
In-Reply-To: <482C58EA.5090904@commandprompt.com>
References: <1210846262.16664.41.camel@philippe-desktop>
<Pine.LNX.4.64.0805151217490.16756@aragorn.flymine.org>
<482C4F3D.6010808@emolecules.com>
<87ve1fwqov.fsf@mnc.ch>
<Pine.LNX.4.64.0805151618520.16756@aragorn.flymine.org>
<87r6c3wpka.fsf@mnc.ch>
<482C58EA.5090904@commandprompt.com>
On Thu, May 15, 2008 at 9:38 AM, Joshua D. Drake <jd@commandprompt.com> wrote:
> Guillaume Cottenceau wrote:
>>
>> Matthew Wakeling <matthew 'at' flymine.org> writes:
>
>> It is still relevant, as with 5% margin, you can afford changing
>> that to 0% with tune2fs, just the time for you to start PG and
>> remove some data by SQL, then shutdown and set the margin to 5%
>> again.
>>
>
> I find that if you actually reach that level of capacity failure it is due
> to lack of management and likely there is much lower hanging fruit left over
> by a lazy dba or sysadmin than having to adjust filesystem level parameters.
>
> Manage actively and the above change is absolutely irrelevant.
Sorry, but that's like saying that open heart surgery isn't a fix for
clogged arteries because you should have been taking aspirin everyday
and exercising. It might not be the best answer, but sometimes it's
the only answer you've got.
I know that being able to drop the margin from x% to 0% for 10 minutes
has pulled more than one db back from the brink for me (usually
consulting on other people's databases, only once or so on my own) :)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, jd@commandprompt.com, gc@mnc.ch, matthew@flymine.org
Subject: Re: which ext3 fs type should I use for postgresql
In-Reply-To: <dcc563d10805161007h5fd1c700ieb185a7979681e49@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox