Re: fragmention issue with ext4: e4defrag?

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: fragmention issue with ext4: e4defrag?
Date: 2014-07-02 18:01:29
Message-ID: 1404324089.35659.YahooMailNeo@web122301.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marc Mamin <M(dot)Mamin(at)intershop(dot)de> wrote:

> I/O througput decreased from 300MB/s to 160.

I don't have any experience with ext4 defrag tools, but just wanted
to point out that the difference in performance you cite above is
about the same as the difference between accessing data on the
outer (and usually first-filled) tracks on a disk drive and the
inner tracks.  One of the reasons performance falls as a drive
fills is that the OS is compelled to use slower and slower portions
of the disk.  Part of the benefit you are seeing might be due to
freeing "fast" tracks and data being relocated there.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2014-07-02 19:01:11 Re: Postgres Replaying WAL slowly
Previous Message Tom Lane 2014-07-02 14:11:19 Re: Hash Join node sometimes slow