Re: VACUUM and read-mostly tables

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: VACUUM and read-mostly tables
Дата
Msg-id 20050405193508.GW93835@decibel.org
обсуждение исходный текст
Ответ на Re: VACUUM and read-mostly tables  (Ian Westmacott <ianw@intellivid.com>)
Список 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.

Actually, I spoke too soon in my last reply. UFS has done work to be
more intelligent about where it allocates space from, so it's very
possible that even if it's only allocating a block at a time that it
will be smart enough not to allocate nearby space for other things. I
believe there's also some tuning parameters that affect that behavior.
Of course, other linux filesystems might be tunable in that regard as
well.
--
Jim C. Nasby, Database Consultant               decibel@decibel.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?"

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: VACUUM and read-mostly tables
Следующее
От: Ian FREISLICH
Дата:
Сообщение: Preventing the schema from being revealed.