Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 559D92E006A for ; Tue, 25 Mar 2008 12:29:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 86379-03 for ; Tue, 25 Mar 2008 12:29:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.177]) by postgresql.org (Postfix) with ESMTP id 777C82E0076 for ; Tue, 25 Mar 2008 12:29:37 -0300 (ADT) Received: by el-out-1112.google.com with SMTP id z25so1924889ele.0 for ; Tue, 25 Mar 2008 08:29:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=i2zI9gGggcQ4kcbhtgNaTuOHP4STD8vRzJn54IguliQ=; b=oQzeEjgeISBjSh5+3y5sw8QVCFt+7d3L7ein3tAfdlnG3M8efYzOWMJ7Km0oH0V4AW5jEI5GjmJ1/UMlq752RFeirhHcoD/S1tR0VO2x1FSfeXD2A9MV+7g+Vb/chX/ZFPiMOC+OWRk4rgUDkrLFChw4LNVa9IaAiKukCZQYawY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=pf+LX9zL/SXW7eKjaXwFZFuTGwWcFtrmSaZQkr9yBFpOgXrWlE54N1xCOlDITeRE3S2tBxV8Wkti0b3bhKiLcWXLwjTLIuH9CBGW5FGdXbX0clyf0fapXL1HCh80/cGqUeJeRHA9byHx/xxaqMINCxxfTbEjYv2oZZ6US9YzxZI= Received: by 10.141.88.3 with SMTP id q3mr3408589rvl.46.1206458976366; Tue, 25 Mar 2008 08:29:36 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Tue, 25 Mar 2008 08:29:36 -0700 (PDT) Message-ID: Date: Tue, 25 Mar 2008 09:29:36 -0600 From: "Scott Marlowe" To: Jack Subject: Re: Tuning Cc: pgsql-admin@postgresql.org In-Reply-To: <002601c88e02$5629fc10$027df430$@com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <002601c88e02$5629fc10$027df430$@com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/214 X-Sequence-Number: 28697 On Mon, Mar 24, 2008 at 4:56 PM, Jack wrote: > > > > > Is there a Postgres equivalent of tkprofs for tuning? you might want to provide an explanation of what tkprofs is and which parts you're interested in emulating in pgsql. Have you read up on explain, explain analyze, and the various pg_stat_* tables? Do any of those help?