Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A6F4B2E00B3 for ; Sun, 8 Jun 2008 22:03:41 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10260-01-3 for ; Sun, 8 Jun 2008 22:03:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms173001pub.verizon.net (vms173001pub.verizon.net [206.46.173.1]) by developer.postgresql.org (Postfix) with ESMTP id E51772E011A for ; Sun, 8 Jun 2008 21:40:43 -0300 (ADT) Received: from ridley.home ([71.179.5.175]) by vms173001.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0K26002H277JRFIY@vms173001.mailsrvcs.net> for pgsql-hackers@postgresql.org; Sun, 08 Jun 2008 19:40:32 -0500 (CDT) Date: Sun, 08 Jun 2008 20:40:31 -0400 From: Robert Treat Subject: Re: pg_dump restore time and Foreign Keys In-reply-to: <24982.1212970335@sss.pgh.pa.us> To: Tom Lane Cc: Simon Riggs , pgsql-hackers@postgresql.org, Andrew Dunstan Message-id: <200806082040.31398.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-15 Content-transfer-encoding: 7bit Content-disposition: inline References: <1212647003.19964.19.camel@ebony.site> <200806081945.33732.xzilla@users.sourceforge.net> <24982.1212970335@sss.pgh.pa.us> User-Agent: KMail/1.9.9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/368 X-Sequence-Number: 119481 On Sunday 08 June 2008 20:12:15 Tom Lane wrote: > Robert Treat writes: > > and i'm sure no one is against that idea, but you're never going to be > > able to match the performance of just avoiding the check. > > We'll never be able to match the performance of not having transactions, > either, but the community has never for a moment considered having a > "no transactions" mode. > it's unclear what a "no transaction" mode would mean, but I'd be willing to guess some people have consider aspects of it (we've just never had agreement) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL