| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Guillaume Cottenceau <gc(at)mnc(dot)ch> |
| Cc: | Matthew Wakeling <matthew(at)flymine(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: which ext3 fs type should I use for postgresql |
| Date: | 2008-05-15 15:38:18 |
| Message-ID: | 482C58EA.5090904@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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.
Joshua D. Drake
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-05-15 15:49:32 | Re: I/O on select count(*) |
| Previous Message | Guillaume Cottenceau | 2008-05-15 15:32:37 | Re: which ext3 fs type should I use for postgresql |