Re: SELECT INTO large FKyed table is slow

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