Large File systems performance issues
We recently moved a database from multiple (20) smaller 250GB ext3 file systems on a linux server RHEL 5.6, to one larger (2TB) file system and are now experiencing performance degradation of about 50%, especially when heavily loaded. This is a data warehouse, so many full table scans, high degree of parallel query, etc. The back end disk is SAN connected EMC. Has anyone had the same experiencing consolidating file systems/volume groups? Our system admins believe the larger chunk of disk is causing the issue, but not sure how to fix it. I hate to split up the database files again