Re: File Fragmentation - Mailing list pgsql-general

From Vick Khera
Subject Re: File Fragmentation
Date
Msg-id CALd+dcdW-AncyafSyRb7CcjLh3mcBd=JpzOkTbOfM0yKKOyueA@mail.gmail.com
Whole thread Raw
In response to Re: File Fragmentation  ("jg" <jg@rilk.com>)
Responses Re: File Fragmentation
Re: File Fragmentation
Re: File Fragmentation
List 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 by date:

Previous
From: Vick Khera
Date:
Subject: Re: "Leaking" disk space on FreeBSD servers
Next
From: Albe Laurenz
Date:
Subject: Re: Matching uppercased russian words (\x0410-\x042F) in UTF8 database 8.4.13