Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key slows down copy/insert - Mailing list pgsql-performance

From Richard van den Berg
Subject Re: Foreign key slows down copy/insert
Date
Msg-id 425FB73F.8080903@trust-factory.com
Whole thread Raw
In response to Re: Foreign key slows down copy/insert  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Foreign key slows down copy/insert  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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
-------------------------------------------

pgsql-performance by date:

Previous
From: Alex
Date:
Subject: plperl vs plpgsql
Next
From: Alan Stange
Date:
Subject: Re: How to improve db performance with $7K?