X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B60E7475FFF for ; Fri, 18 Apr 2003 11:13:05 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id D84B4475458 for ; Fri, 18 Apr 2003 11:12:34 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id ADCA9D624; Fri, 18 Apr 2003 08:12:39 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 9F44B5C02; Fri, 18 Apr 2003 08:12:39 -0700 (PDT) Date: Fri, 18 Apr 2003 08:12:39 -0700 (PDT) From: Stephan Szabo To: Tom Lane Cc: Kevin Brown , Subject: Re: [PERFORM] Foreign key performance In-Reply-To: <3990.1050677499@sss.pgh.pa.us> Message-ID: <20030418080950.R2132-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-25.8 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, 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/695 X-Sequence-Number: 38185 On Fri, 18 Apr 2003, Tom Lane wrote: > Stephan Szabo writes: > > 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're on Linux? You need to compile postmaster.c with -DLINUX_PROFILE. Yep, thanks. :) > But the call counts do sound pretty damning. Yeah, but even with my hack last night it was still appreciably slower than immediate constraints. Comparing the call counts in that function for the immediate versus deferred(hacked) weren't giving me a good idea of where that time was going.