X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C0511475CC4 for ; Fri, 21 Feb 2003 21:50:35 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 30206-05 for ; Fri, 21 Feb 2003 21:50:08 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 6D1D7475DD7 for ; Fri, 21 Feb 2003 21:24:38 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1M2Od5u002074; Fri, 21 Feb 2003 21:24:39 -0500 (EST) To: Kevin White Cc: pgsql-performance@postgresql.org Subject: Re: Really bad insert performance: what did I do wrong? In-reply-to: <3E566022.5010200@digital-ics.com> References: <3E564695.7030906@digital-ics.com> <20030221115917.A16866@mail.libertyrms.com> <3E566022.5010200@digital-ics.com> Comments: In-reply-to Kevin White message dated "Fri, 21 Feb 2003 12:21:38 -0500" Date: Fri, 21 Feb 2003 21:24:39 -0500 Message-ID: <2073.1045880679@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/163 X-Sequence-Number: 1219 Kevin White writes: > I did this, but my gmon.out doesn't appear to have much data from the > actual child postgres process, just the parent. Are you looking in the right place? Child processes will dump gmon.out into $PGDATA/base/yourdbnum/, which is not where the parent process does. regards, tom lane