Re: SELECT INTO large FKyed table is slow

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Mario Splivalo" <mario(dot)splivalo(at)megafon(dot)hr>, "Mladen Gogala" <mladen(dot)gogala(at)vmsinfo(dot)com>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "jd(at)commandprompt(dot)com" <jd(at)commandprompt(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SELECT INTO large FKyed table is slow
Date: 2010-12-01 21:43:08
Message-ID: op.vm1096ukeorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 01 Dec 2010 18:24:35 +0100, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

> Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mario Splivalo 2010-12-02 08:36:40 Re: SELECT INTO large FKyed table is slow
Previous Message Mladen Gogala 2010-12-01 21:07:35 Re: SELECT INTO large FKyed table is slow