X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4033F47630C for ; Fri, 25 Apr 2003 15:53:25 -0400 (EDT) Received: from europa.janwieck.net (h00045a2e4e7c.ne.client2.attbi.com [24.131.181.55]) by postgresql.org (Postfix) with ESMTP id 729FC4763D8 for ; Fri, 25 Apr 2003 15:53:19 -0400 (EDT) Received: from Yahoo.com (wieck@dhcpclnt00.janwieck.net [192.168.192.100]) (authenticated) by europa.janwieck.net (8.11.6/8.11.6) with ESMTP id h3PJqba24259; Fri, 25 Apr 2003 15:52:38 -0400 Message-ID: <3EA991F0.A201AC38@Yahoo.com> Date: Fri, 25 Apr 2003 15:52:16 -0400 From: Jan Wieck Organization: Home X-Mailer: Mozilla 4.8 [en] (Windows NT 5.0; U) X-Accept-Language: en,ru MIME-Version: 1.0 To: Stephan Szabo Cc: Tom Lane , Kevin Brown , pgsql-hackers@postgresql.org Subject: Re: [PERFORM] Foreign key performance References: <20030418073753.B1912-100000@megazone23.bigpanda.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-29.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/905 X-Sequence-Number: 38395 Stephan Szabo wrote: > > [Not sure this really is relevant for -performance at this point] > > On Thu, 17 Apr 2003, Stephan Szabo wrote: > > > On Fri, 18 Apr 2003, Tom Lane wrote: > > > > > Stephan Szabo writes: > > > > It appears (from some not terribly scientific experiments - see below) > > > > that it's likely to be related to managing the deferred trigger queue > > > > given that in my case at least running the constraints non-deferred was > > > > negligible in comparison. > > > > > > At one time the deferred-trigger queue had an O(N^2) behavioral problem > > > for large N = number of pending trigger events. But I thought we'd > > > fixed that. What's the test case exactly? Can you get a profile with > > > gprof? > > > > I'm going to tomorrow hopefully - but it looks to me that we fixed one, but > > Argh. I'm getting that state where gprof returns all 0s for times. I'm > pretty sure this has come up before along with how to get it to work, but > I couldn't find it in the archives. Someday I'll learn how to use gprof. :( You have to save and restore the timers around the fork() under Linux. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #