| From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | fragmention issue with ext4: e4defrag? |
| Date: | 2014-07-02 08:51:16 |
| Message-ID: | B6F6FD62F2624C4C9916AC0175D56D8828A9B485@jenmbs01.ad.intershop.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello,
Has anyone some experience using defragmentation tools on Linux against tablespaces ?
we are facing fragmentation problems with postgres instances having a few TB of data.
( RAID 5 )
I/O througput decreased from 300MB/s to 160.
- We first moved some schemas to separate servers.
After that we still have 150'000 tables in 1.5 TB
- Now we are in the process of vacuuming FULL historical tables which are not written anymore.
This seems to improve the I/O considerably
Our remaining issue is that the free space fragmentíon is still suboptimal
so that fragmention will probably start again soon.
Would it make sense to use a tool like e4defrag
(http://www.linux.org/threads/online-defragmentation.4121/)
in order to defrag the free space ?
And how safe is it to use such a tool against a running postgres instance?
many thanks,
Marc Mamin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Roberge | 2014-07-02 13:01:47 | Hash Join node sometimes slow |
| Previous Message | Niels Kristian Schjødt | 2014-07-01 20:08:32 | Re: Guidelines on best indexing strategy for varying searches on 20+ columns |