pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Is Indexed View Supported in psql 7.1.3?? 3+ messages / 3 participants [nested] [flat]
* Is Indexed View Supported in psql 7.1.3?? @ 2005-04-06 12:31 S.Thanga Prakash <thanga@midascomm.com> 2005-04-11 05:03 ` Re: Is Indexed View Supported in psql 7.1.3?? Christopher Kings-Lynne <chriskl@familyhealth.com.au> 2005-04-11 05:35 ` Re: Is Indexed View Supported in psql 7.1.3?? Steve Poe <spoe@sfnet.cc> 0 siblings, 2 replies; 3+ messages in thread From: S.Thanga Prakash @ 2005-04-06 12:31 UTC (permalink / raw) To: pgsql-performance hi, I like to know whether Indexed View supported in psql 7.1.3.? Is there any performance analysis tool for psql.? Please! update me for the same. regards, stp. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Is Indexed View Supported in psql 7.1.3?? 2005-04-06 12:31 Is Indexed View Supported in psql 7.1.3?? S.Thanga Prakash <thanga@midascomm.com> @ 2005-04-11 05:03 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au> 1 sibling, 0 replies; 3+ messages in thread From: Christopher Kings-Lynne @ 2005-04-11 05:03 UTC (permalink / raw) To: thanga@midascomm.com; +Cc: pgsql-performance > I like to know whether Indexed View supported in psql 7.1.3.? No... > Is there any performance analysis tool for psql.? No, we keep telling you to upgrade to newer PostgreSQL. Then you can use EXPLAIN ANALYZE. Chris ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Is Indexed View Supported in psql 7.1.3?? 2005-04-06 12:31 Is Indexed View Supported in psql 7.1.3?? S.Thanga Prakash <thanga@midascomm.com> @ 2005-04-11 05:35 ` Steve Poe <spoe@sfnet.cc> 1 sibling, 0 replies; 3+ messages in thread From: Steve Poe @ 2005-04-11 05:35 UTC (permalink / raw) To: thanga@midascomm.com; +Cc: pgsql-performance 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-11 05:35 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-04-06 12:31 Is Indexed View Supported in psql 7.1.3?? S.Thanga Prakash <thanga@midascomm.com> 2005-04-11 05:03 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au> 2005-04-11 05:35 ` Steve Poe <spoe@sfnet.cc>
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