On Wed, Apr 29, 2015 at 07:07:04AM -0700, Joshua D. Drake wrote: > > On 04/29/2015 01:08 AM, Andres Freund wrote: > > >>Which OS and filesystem is this done on? Because many halfway modern > >>systems, like e.g ext4 and xfs, implement this in the background as > >>'delayed allocation'. > > > >Oh, it's in the subject. Stupid me, sorry for that. I'd consider testing > >how much better this behaves under a different operating system, as a > >shorter term relief. > > This is a known issue on the Windows platform. It is part of the > limitations of that environment. Linux/Solaris/FreeBSD do not suffer > from this issue in nearly the same manner. > > jD >
You might consider a CLUSTER or VACUUM FULL to re-write the table with less fragmentation. Regards, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
