Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3441D1337BB8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  2 Dec 2010 04:51:15 -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 46370-04
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  2 Dec 2010 08:51:08 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out.mail.amis.hr (out2.mail.amis.hr [188.129.0.5])
	by mail.postgresql.org (Postfix) with ESMTP id A9E8B1337B2F
	for <pgsql-performance@postgresql.org>;
	Thu,  2 Dec 2010 04:51:07 -0400 (AST)
Received: from out.fsec.sm.srv.amis.hr (out.fsec.sm.srv.amis.hr
	[192.168.106.22])
	by out.mail.amis.hr (Postfix) with ESMTP id DD8DE2018D;
	Thu,  2 Dec 2010 09:51:06 +0100 (CET)
Received: from pps.filterd (out [127.0.0.1])
	by out.fsec.sm.srv.amis.hr (8.14.3/8.14.3) with SMTP id oB28ll9V024103;
	Thu, 2 Dec 2010 09:51:06 +0100
Received: from smtp.amis.hr (smtp.sm.srv.amis.hr [192.168.106.39])
	by out.fsec.sm.srv.amis.hr with ESMTP id swn6vrrbc-1;
	Thu, 02 Dec 2010 09:51:06 +0100
A-Original-Client-UID: 188.129.75.173 splivalo
Received: from [192.168.10.1] (cpe-188-129-75-173.dynamic.amis.hr
	[188.129.75.173])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested) (Authenticated sender: splivalo)
	by smtp.amis.hr (Postfix) with ESMTPSA id 9302B391;
	Thu,  2 Dec 2010 09:51:05 +0100 (CET)
Message-ID: <4CF75DF9.1030301@megafon.hr>
Date: Thu, 02 Dec 2010 09:51:05 +0100
From: Mario Splivalo <mario.splivalo@megafon.hr>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.15) Gecko/20101027 Lightning/1.0b1 Thunderbird/3.0.10
MIME-Version: 1.0
To: Pierre C <lists@peufeu.com>
CC: Mladen Gogala <mladen.gogala@vmsinfo.com>,
	Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	"jd@commandprompt.com" <jd@commandprompt.com>,
	"pgsql-performance@postgresql.org" <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>
	<op.vm1096ukeorkce@apollo13>
In-Reply-To: <op.vm1096ukeorkce@apollo13>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15, 1.0.148,
	0.0.0000
	definitions=2010-12-02_04:2010-12-02, 2010-12-02,
	1970-01-01 signatures=0
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0
	ipscore=0 suspectscore=0
	phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0
	reason=mlx
	engine=6.0.2-1010190000 definitions=main-1012020006
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
X-Spam-Level: 
X-Archive-Number: 201012/21
X-Sequence-Number: 41473

On 12/01/2010 10:43 PM, Pierre C wrote:
> On Wed, 01 Dec 2010 18:24:35 +0100, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
>
>> Mladen Gogala <mladen.gogala@vmsinfo.com> 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.

It is OT, but, could you please shead just some light on that? Part of 
my next project is to test performance of pg9 on both windows and linux 
systems so I'd appreciate any data/info you both may have.

	Mario