X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D6DE65336B for ; Mon, 11 Apr 2005 02:35:39 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83165-02 for ; Mon, 11 Apr 2005 05:35:36 +0000 (GMT) Received: from mail.tecarta.com (66.238.115.135.ptr.us.xo.net [66.238.115.135]) by svr1.postgresql.org (Postfix) with ESMTP id 9C80552A8D for ; Mon, 11 Apr 2005 02:35:35 -0300 (ADT) Received: from mail pickup service by mail.tecarta.com with Microsoft SMTPSVC; Sun, 10 Apr 2005 22:38:34 -0700 Received: from mail.tecarta.com ([192.168.160.2]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Sun, 10 Apr 2005 22:38:30 -0700 Received: from barracuda.tecarta.com ([192.168.160.200]) by mail.tecarta.com (SAVSMTP 3.1.0.29) with SMTP id M2005041022382922002 for ; Sun, 10 Apr 2005 22:38:29 -0700 X-ASG-Debug-ID: 1113197728-16231-0-0 X-Barracuda-URL: http://192.168.160.200:8000/cgi-bin/mark.cgi Received: from mail1 (mail1.hq.corp [192.168.160.5]) by barracuda.tecarta.com (Spam Firewall) with SMTP id F407220080FE for ; Sun, 10 Apr 2005 22:35:28 -0700 (PDT) Received: from [192.168.0.13] ([63.206.203.145]) by mail.tecarta.com with Microsoft SMTPSVC(6.0.3790.0); Sun, 10 Apr 2005 22:38:21 -0700 Message-ID: <425A0C8C.3040300@sfnet.cc> Date: Sun, 10 Apr 2005 22:35:08 -0700 From: Steve Poe User-Agent: Mozilla Thunderbird 1.0 (X11/20041228) X-Accept-Language: en-us, en MIME-Version: 1.0 To: thanga@midascomm.com Cc: pgsql-performance@postgresql.org X-ASG-Orig-Subj: Re: [PERFORM] Is Indexed View Supported in psql 7.1.3?? Subject: Re: Is Indexed View Supported in psql 7.1.3?? References: <2038.192.168.13.108.1112790695.squirrel@192.168.13.108> In-Reply-To: <2038.192.168.13.108.1112790695.squirrel@192.168.13.108> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 11 Apr 2005 05:38:21.0365 (UTC) FILETIME=[ABFFF650:01C53E58] X-Virus-Scanned: by Barracuda Spam Firewall at tecarta.com X-Barracuda-Spam-Score: -0.41 X-Barracuda-Spam-Status: No, SCORE=-0.41 using global scores of TAG_LEVEL=4.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests=BAYES_05 X-Barracuda-Spam-Report: Code version 3.02, rules version 3.0.205 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- -0.41 BAYES_05 BODY: Bayesian spam probability is 1 to 5% [score: 0.0328] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.198 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/211 X-Sequence-Number: 11608 stp, I cannot help you with the first point, but as far as performance analysis, I share with you what I've been using. 1) pgbench -- which comes with PostgreSQL 2) OSDB (http://osdb.sourceforge.net/) 3) pg_autotune (http://pgfoundry.org/projects/pgautotune/) 4) PQA (http://pgfoundry.org/projects/pqa/) You did not mention how your database is being used/going to be used. If its already in production, use PQA, but I personally have not implemented yet since seemed to be to take a performance hit of 15-25% when running it. Your mileage may vary. I use pgbench for quick tests and OSDB for more disk thrash testing. I am new to this; maybe someone else may be able to speak from more experience. Regards. Steve Poe