Re: preliminary testing, two very slow situations... - Mailing list pgsql-performance

From Tom Lane
Subject Re: preliminary testing, two very slow situations...
Date
Msg-id 8337.1041454873@sss.pgh.pa.us
Whole thread Raw
In response to Re: preliminary testing, two very slow situations...  ("Neil Conway" <neilc@samurai.com>)
List pgsql-performance
"Neil Conway" <neilc@samurai.com> writes:
> Michael Teter said:
>> Now I'm trying to evaluate it as a possible
>> replacement for MS SQL Server.

> What version of PostgreSQL are you using?
> [suggestions for tuning]

The only reason I can think of for COPY to be as slow as Michael is
describing is if it's checking foreign-key constraints (and even then
it'd have to be using very inefficient plans for the check queries).
So we should ask not only about the PG version, but also about the
exact table declarations involved.

            regards, tom lane

pgsql-performance by date:

Previous
From: Ron Johnson
Date:
Subject: Re: alter table TBL add constraint TBL_FK foreign key
Next
From: george young
Date:
Subject: Re: preliminary testing, two very slow situations...