Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A87621337B47 for ; Wed, 1 Dec 2010 17:43:21 -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 45919-01 for ; Wed, 1 Dec 2010 21:43:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from 30.mail-out.ovh.net (30.mail-out.ovh.net [213.186.62.213]) by mail.postgresql.org (Postfix) with SMTP id 08389133740B for ; Wed, 1 Dec 2010 17:43:13 -0400 (AST) Received: (qmail 7819 invoked by uid 503); 1 Dec 2010 21:18:57 -0000 Received: from b6.ovh.net (HELO mail432.ha.ovh.net) (213.186.33.56) by 30.mail-out.ovh.net with SMTP; 1 Dec 2010 21:18:57 -0000 Received: from b0.ovh.net (HELO queueout) (213.186.33.50) by b0.ovh.net with SMTP; 1 Dec 2010 23:43:11 +0200 Received: from par69-8-88-161-102-87.fbx.proxad.net (HELO apollo13) (lists%peufeu.com@88.161.102.87) by ns0.ovh.net with SMTP; 1 Dec 2010 23:43:09 +0200 Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes To: "Mario Splivalo" , "Mladen Gogala" , "Kevin Grittner" Cc: "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> <4CF63073020000250003802E@gw.wicourts.gov> Date: Wed, 01 Dec 2010 22:43:08 +0100 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: "Pierre C" Message-ID: In-Reply-To: <4CF63073020000250003802E@gw.wicourts.gov> User-Agent: Opera Mail/10.62 (Linux) X-Ovh-Tracer-Id: 13937796423406454390 X-Ovh-Remote: 88.161.102.87 (par69-8-88-161-102-87.fbx.proxad.net) X-Ovh-Local: 213.186.33.20 (ns0.ovh.net) X-Spam-Check: DONE|U 0.5/N 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: 201012/19 X-Sequence-Number: 41471 On Wed, 01 Dec 2010 18:24:35 +0100, Kevin Grittner wrote: > Mladen Gogala wrote: > >> 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" > Been there, done that. Not only was performance quite poor compared > to Linux, but reliability and staff time to manage things suffered > in comparison to Linux. Please don't start with NTFS. It is the worst excuse for a filesystem I've ever seen.