Re: File Fragmentation

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: File Fragmentation
Дата
Msg-id CALd+dcdW-AncyafSyRb7CcjLh3mcBd=JpzOkTbOfM0yKKOyueA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: File Fragmentation  ("jg" <jg@rilk.com>)
Ответы Re: File Fragmentation
Re: File Fragmentation
Re: File Fragmentation
Список pgsql-general

On Wed, Mar 20, 2013 at 9:53 AM, jg <jg@rilk.com> wrote:
The rotated script, as explained, just drops tables and creates empty ones.

That doesn't make sense then, to have fragmentation if you are creating new tables with fresh data copied into them.  The files should be pretty much sequentially written.

Ohhhh.... I see. You're using Windows. Maybe you need some OS with a better file system that doesn't fragment like that?

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

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: "Leaking" disk space on FreeBSD servers
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13