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