Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EAD0E13364DE for ; Mon, 31 Jan 2011 00:53:37 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 15884-01 for ; Mon, 31 Jan 2011 04:53:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hrndva-omtalb.mail.rr.com (hrndva-omtalb.mail.rr.com [71.74.56.125]) by mail.postgresql.org (Postfix) with ESMTP id 99C0D1337B69 for ; Mon, 31 Jan 2011 00:53:30 -0400 (AST) Received: from hrndva-omtalb.mail.rr.com ([10.128.143.53]) by hrndva-qmta02.mail.rr.com with ESMTP id <20110131044447001.UXCP11884@hrndva-qmta02.mail.rr.com> for ; Mon, 31 Jan 2011 04:44:47 +0000 X-Authority-Analysis: v=1.1 cv=+c36koQ5Dcj/1qolKHjtkYAGXvrVJRRiKMp+84F5sLg= c=1 sm=0 a=2BCD2sDEcfQA:10 a=JRZeEW2aRuwA:10 a=-CRmgG0JhlAA:10 a=RAii6je2cdnAH6ATCOpc6g==:17 a=_Ixf_7qHAAAA:8 a=fOye8ciQ_v4pV8Jz0CEA:9 a=aztKoQ93wWJH_uLyWkdouUUTPnAA:4 a=jiObf9B0YAUA:10 a=ryAo9hy1-OkA:10 a=6vsjEBoLwlAA:10 a=0tfO7MgyNwYA:10 a=RAii6je2cdnAH6ATCOpc6g==:117 X-Cloudmark-Score: 0 X-Originating-IP: 74.73.87.196 Received: from [74.73.87.196] ([74.73.87.196:36955] helo=[192.168.1.100]) by hrndva-oedge03.mail.rr.com (envelope-from ) (ecelerity 2.2.3.46 r()) with ESMTP id B7/2A-24070-10E364D4; Mon, 31 Jan 2011 04:43:45 +0000 Message-ID: <4D463B7E.9070304@vmsinfo.com> Date: Sun, 30 Jan 2011 23:33:02 -0500 From: Mladen Gogala Reply-To: mladen.gogala@vmsinfo.com Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101213) MIME-Version: 1.0 To: =?ISO-8859-2?Q?Marcin_Miros=B3aw?= CC: "pgsql-performance@postgresql.org" Subject: Re: Any experience using "shake" defragmenter? References: <4D45C607.4070101@vmsinfo.com> <4D45E5C4.1090203@mejor.pl> In-Reply-To: <4D45E5C4.1090203@mejor.pl> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201101/342 X-Sequence-Number: 42129 Marcin Mirosław wrote: > W dniu 2011-01-30 22:31, Mark Felder pisze: > >> Why do you feel the need to defrag your *nix box? >> > > I'm guessing, maybe he used filefrag and saw >30000 extents? :) > Next question will be "which fs do you use?" and then flame will start:( > Regards > > With all due respect, I don't want to start a fruitless flame war. I am asking those who have used it about their experiences with the product. Let's leave discussion of my motivation for some other time. I guess it's all about my unhappy childhood. If you have used the defragmenter, I'd be grateful for your experience. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com