From: Steve Poe <spoe@sfnet.cc>
To: thanga@midascomm.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Is Indexed View Supported in psql 7.1.3??
Date: Sun, 10 Apr 2005 22:35:08 -0700
Message-ID: <425A0C8C.3040300@sfnet.cc> (raw)
In-Reply-To: <2038.192.168.13.108.1112790695.squirrel@192.168.13.108>
References: <2038.192.168.13.108.1112790695.squirrel@192.168.13.108>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: spoe@sfnet.cc, thanga@midascomm.com
Subject: Re: Is Indexed View Supported in psql 7.1.3??
In-Reply-To: <425A0C8C.3040300@sfnet.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox