On Wed, Dec 01, 2010 at 12:15:19PM -0500, Mladen Gogala wrote: > Mario Splivalo wrote: >> I'll try what Pierre suggested, on whole new filesystem. This one did get >> quite filled with thousands of files that I deleted while the database was >> working. >> >> Mario >> > > Yes, that is a good idea. That's the reason why we need a defragmentation > tool on Linux. Unfortunately, the only file system that currently has a > decent defragmentation tool is XFS and that is a paid option, at least with > Red Hat. Greg Smith has recently posted a wonderful review of PostgreSQL on > various file systems: > > http://blog.2ndquadrant.com/en/2010/04/the-return-of-xfs-on-linux.html > > There is a operating system which comes with a very decent extent based > file system and a defragmentation tool, included in the OS. The file system > is called "NTFS" and company is in the land of Redmond, WA where the > shadows lie. One OS to rule them all... > > -- > Mladen Gogala Sr. Oracle DBA > 1500 Broadway > New York, NY 10036 > (212) 329-5251 > http://www.vmsinfo.com The Leader in Integrated Media Intelligence > Solutions > Redhat6 comes with ext4 which is an extent based filesystem with decent performance. Ken -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
