| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | Ian Westmacott <ianw(at)intellivid(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: VACUUM and read-mostly tables |
| Date: | 2005-04-05 19:32:03 |
| Message-ID: | 20050405193203.GV93835@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Apr 05, 2005 at 01:56:05PM -0400, Ian Westmacott wrote:
> > And if UFS is available for linux you should might try it.
>
> Would UFS help the fragmentation issue? We have seen ext3
> allocating blocks in 2-4 pages, while XFS manages 8-16
> pages.
Hrm... I'm not sure what the allocation stratedgy is. I guess this is a
case where it would be useful to tell postgresql to allocate space for a
table in large chunks.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-04-05 19:35:08 | Re: VACUUM and read-mostly tables |
| Previous Message | Tom Lane | 2005-04-05 18:26:54 | Re: VACUUM and read-mostly tables |