From: | "jg" <jg(at)rilk(dot)com> |
---|---|
To: | "Vick Khera" <vivek(at)khera(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: File Fragmentation |
Date: | 2013-03-20 14:23:04 |
Message-ID: | 5efd-5149c680-1-6b8b4580@60844246 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
> 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?
I know OS other than Windows will be better.
But, I think on any OS, I would have some trouble because the pattern of IO.
Each minute, each of the 50 tables has 10,000 new rows COPYed.
Normaly the filesystem try to keep the file (under the tables) continous with few fragment.
But the pattern is such, that it seems to me really difficult to prevent it.
Do you have any idea to mitigate the problem on Windows ?
JG
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2013-03-20 14:34:31 | Re: "Leaking" disk space on FreeBSD servers |
Previous Message | Adrian Klaver | 2013-03-20 14:22:52 | Re: File Fragmentation |