Re: PostgreSQL disk fragmentation causes performance problems on Windows

Поиск
Список
Период
Сортировка
От ktm@rice.edu
Тема Re: PostgreSQL disk fragmentation causes performance problems on Windows
Дата
Msg-id 20150429143543.GQ3510@aart.rice.edu
обсуждение исходный текст
Ответ на Re: PostgreSQL disk fragmentation causes performance problems on Windows  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: PostgreSQL disk fragmentation causes performance problems on Windows  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-performance
On Wed, Apr 29, 2015 at 07:07:04AM -0700, Joshua D. Drake wrote:
>
> On 04/29/2015 01:08 AM, Andres Freund wrote:
>
> >>Which OS and filesystem is this done on? Because many halfway modern
> >>systems, like e.g ext4 and xfs, implement this in the background as
> >>'delayed allocation'.
> >
> >Oh, it's in the subject. Stupid me, sorry for that. I'd consider testing
> >how much better this behaves under a different operating system, as a
> >shorter term relief.
>
> This is a known issue on the Windows platform. It is part of the
> limitations of that environment. Linux/Solaris/FreeBSD do not suffer
> from this issue in nearly the same manner.
>
> jD
>

You might consider a CLUSTER or VACUUM FULL to re-write the table with
less fragmentation.

Regards,
Ken


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: PostgreSQL disk fragmentation causes performance problems on Windows
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: PostgreSQL disk fragmentation causes performance problems on Windows