Re: Foreign key slows down copy/insert

From: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PFC <lists(at)boutiquenumerique(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Foreign key slows down copy/insert
Date: 2005-04-15 14:10:04
Message-ID: 425FCB3C.8010809@trust-factory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:
> You didn't show us any \timing. The 94.109 ms figure is all server-side.

Whoop, my mistake. I had been retesting without the explain, just the
query. I re-run the explain analyze a few times, and it only reports
90ms the first time. After that it reports 2ms even over the network
(the \timing on those are about 50ms which includes the network latency).

Thanks,

--
Richard van den Berg, CISSP
-------------------------------------------
Trust Factory B.V. | www.dna-portal.net
Bazarstraat 44a | www.trust-factory.com
2518AK The Hague | Phone: +31 70 3620684
The Netherlands | Fax : +31 70 3603009
-------------------------------------------

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard_D_Levine 2005-04-15 14:21:02 Re: Intel SRCS16 SATA raid?
Previous Message Tom Lane 2005-04-15 14:06:06 Re: speed of querry?