Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8EBB81337B91 for ; Wed, 1 Dec 2010 13:33:36 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 81358-01 for ; Wed, 1 Dec 2010 17:33:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lpo-relay-04.vmsinfo.com (lpo-relay-04.vmsinfo.com [216.169.137.115]) by mail.postgresql.org (Postfix) with ESMTP id E63DC1337B90 for ; Wed, 1 Dec 2010 13:33:28 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.59,284,1288584000"; d="scan'208";a="27295374" Received: from unknown (HELO lpo-mailbox-01.vmsinfo.com) ([216.169.137.251]) by lpo-relay-04.vmsinfo.com with ESMTP; 01 Dec 2010 12:33:28 -0500 Received: from [10.101.43.35] (unknown [216.169.135.235]) by lpo-mailbox-01.vmsinfo.com (Postfix) with ESMTP id 521977D00B; Wed, 1 Dec 2010 12:33:28 -0500 (EST) Message-ID: <4CF686E7.4040207@vmsinfo.com> Date: Wed, 01 Dec 2010 12:33:27 -0500 From: Mladen Gogala Organization: VMS User-Agent: Thunderbird 2.0.0.24 (X11/20101027) MIME-Version: 1.0 To: Kenneth Marshall CC: Mario Splivalo , "jd@commandprompt.com" , "pgsql-performance@postgresql.org" Subject: Re: SELECT INTO large FKyed table is slow References: <4CF24103.8030209@megafon.hr> <1291168052.20631.1963.camel@jd-desktop> <4CF5FF0A.9040605@megafon.hr> <4CF678FC.9050003@vmsinfo.com> <4CF67F2A.4070703@megafon.hr> <4CF682A7.4030109@vmsinfo.com> <20101201172208.GS19162@aart.is.rice.edu> In-Reply-To: <20101201172208.GS19162@aart.is.rice.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/17 X-Sequence-Number: 41469 Kenneth Marshall wrote: > Redhat6 comes with ext4 which is an extent based filesystem with > decent performance. > > Ken > But e4defrag is still not available. And, of course, Red Hat 6 is still not available, either. Maybe Red Hat 7 will do the trick? I assume it will work beautifully with PostgreSQL 15.0. -- 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