Re: Foreign key slows down copy/insert

From: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: PFC <lists(at)boutiquenumerique(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Foreign key slows down copy/insert
Date: 2005-04-15 12:44:47
Message-ID: 425FB73F.8080903@trust-factory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Christopher Kings-Lynne wrote:
> No explain analyze is done on the server...

Yes, but the psql \timing is calculated on the client, right? That is
the value that PFC was refering to.

--
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2005-04-15 12:57:33 Re: plperl vs plpgsql
Previous Message Alex 2005-04-15 11:49:07 plperl vs plpgsql