Re: PostgreSQL win32 fragmentation issue

Alvaro Herrera wrote:
> Joshua D. Drake wrote:
>
>> My concern is that this is over a single bench run. I could imagine that
>> after a week or two weeks of stead PostgreSQL use, the IO would
>> gradually get worse and worse.
>
> Well, we mostly do random reads (seek) all the time anyway, so is this
> really a concern?
>
> Are you using NTFS or FAT?  You didn't answer that question.
>

If it's FAT then you deserve what you get.

If you really need this, a Slony setup would probably work well. Shut down
replica, defrag, start up replica, wait for sync completion, switchover
and repeat. The new Slony release is said to support Windows.

cheers

andrew