pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / 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