Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT INTO large FKyed table is slow - Mailing list pgsql-performance

From Pierre C
Subject Re: SELECT INTO large FKyed table is slow
Date
Msg-id op.vm1096ukeorkce@apollo13
Whole thread Raw
In response to Re: SELECT INTO large FKyed table is slow  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: SELECT INTO large FKyed table is slow
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: Mario Splivalo
Date:
Subject: Re: SELECT INTO large FKyed table is slow