Search Postgresql Archives

Re: File Fragmentation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Wed, Mar 20, 2013 at 9:53 AM, jg <jg@xxxxxxxx> 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?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux