Received: with ECARTIS (v1.0.0; list linux-xfs); Tue, 02 Nov 2004 08:23:40 -0800 (PST) Received: from mail.linux-sxs.org (mail.linux-sxs.org [64.116.183.6]) by oss.sgi.com (8.13.0/8.13.0) with ESMTP id iA2GNbw2008137 for ; Tue, 2 Nov 2004 08:23:38 -0800 Received: from mail.linux-sxs.org (localhost [127.0.0.1]) by mail.linux-sxs.org (8.13.1/8.13.1/Debian-15) with ESMTP id iA2FsxM1009186 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 2 Nov 2004 10:54:59 -0500 Received: from localhost (netllama@localhost) by mail.linux-sxs.org (8.13.1/8.13.1/Submit) with ESMTP id iA2Fsx4k009183; Tue, 2 Nov 2004 10:54:59 -0500 X-Authentication-Warning: mail.linux-sxs.org: netllama owned process doing -bs Date: Tue, 2 Nov 2004 10:54:59 -0500 (EST) From: Net Llama! To: "Benito A. Venegas" cc: linux-xfs@oss.sgi.com Subject: Re: XFS/Postgres/Fragmentation In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Scanned-By: milter-sender/0.60.818 (localhost [127.0.0.1]); Tue, 02 Nov 2004 10:55:00 -0500 X-archive-position: 4372 X-ecartis-version: Ecartis v1.0.0 Sender: linux-xfs-bounce@oss.sgi.com Errors-to: linux-xfs-bounce@oss.sgi.com X-original-sender: netllama@linux-sxs.org Precedence: bulk X-list: linux-xfs On Sun, 31 Oct 2004, Benito A. Venegas wrote: > Hi people, > > Thanks to everybody for your great effort day by day to maintain this > great project... > > Now..my problem.. :( > > I'm experiencing some high fragmentations in one of my boxes, running > postgresql database. > > Last Friday/Saturday I ran some extra maintenance to my postgres DB > (reindexing, analyze, vacuum full, etc.) due suddenly we started to have > very slow performance in our queries. This maintenance helped, but later > I ran xfs_db -r -c "frag -f" and the > fragmentation was still high (close to 90%) and xfs_fsr reduced it to 7% > after to complete 10 loops for all my file systems in /etc/mtab. > > Today in the evening I took some statistics and fragmentations level was > 64% !! :( > > #xfs_db -r /dev/sdc1 -c "frag -f" > actual 2531, ideal 906, fragmentation factor 64.20% > > > Basic info: > > -kernel 2.4.19 + xfs 1.2 + some extra patches > -postgres 7.2.3-1PGDG > > #xfs_info /proj > > meta-data=/proj isize=256 agcount=34, agsize=262144 > blks > data = bsize=4096 blocks=8885945, imaxpct=25 > = sunit=0 swidth=0 blks, unwritten=0 > naming =version 2 bsize=4096 > log =internal bsize=4096 blocks=1200 version=1 > = sunit=0 blks > realtime =none extsz=65536 blocks=0, rtextents=0 > > -HW level > PE2650 PIII 1400 Mhz Dual CPU, 1Gb ram, > /proj is in RAID1 using Perc3/Di (Yes, I know this is a bad raid card, > but IMHO this is not causing the fragmentations) > Only postgres and a small mysql DB are using this partition. I provided my xfs_info and uname in a separate email. However, here's the xfs_db output: xfs_db -r /dev/sda3 -c "frag -f" actual 249616, ideal 247369, fragmentation factor 0.90% as you can see, i've got virtully no fragmentation at all. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Lonni J Friedman netllama@linux-sxs.org Linux Step-by-step & TyGeMo http://netllama.ipfox.com