Re: [PERFORM] SELECT INTO large FKyed table is slow

2010-12-02 Thread Mario Splivalo
On 12/01/2010 09:43 AM, Pierre C wrote: Note that in both cases postgres reports that the FK checks take 92-120 milliseconds... which is a normal time for about 4000 rows. Inserting 4000 lines with just a few fields like you got should take quite much less than 1 s... Where the rest of the time

Re: [PERFORM] SELECT INTO large FKyed table is slow

2010-12-02 Thread Mario Splivalo
On 12/01/2010 10:43 PM, Pierre C wrote: 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 t

Re: [PERFORM] SELECT INTO large FKyed table is slow

2010-12-02 Thread Kevin Grittner
Mario Splivalo wrote: > 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. I don't know how much was the filesystem, but with both tuned

[PERFORM] Multicore Postgres 9.0.1 issue - single transaction problem.

2010-12-02 Thread Piotr Czekalski
Hello Postgres Users. Last days I've installed and configured new x64 release of PostgreSQL running Windows 2008 R2 with dual XEON 5530 processors (2x4xHT = 16 working units). Previously the database was running on Fedora 12 x86_64 under Microsoft hypervisor (HyperV) thus because of the networ

Re: [PERFORM] Multicore Postgres 9.0.1 issue - single transaction problem.

2010-12-02 Thread Scott Marlowe
On Thu, Dec 2, 2010 at 2:04 PM, Piotr Czekalski wrote: > Hello Postgres Users. > > Last days I've installed and configured new x64 release of PostgreSQL > running Windows 2008 R2 with dual XEON 5530 processors (2x4xHT = 16 working > units). Previously the database was running on Fedora 12 x86_64 u