Hello!

I'm managing the db of a "Content Management environment" and I'm
searching for a "Query analyzer" to improve performance because i don't
know how many and what type of queries are executing on the system (for
the "where and join" block).

If i could have query's stats i could Optimize the queries indexes.

Thank's a lot!

Marco "Furetto" Berri




Reimer wrote:
Marco,

Could you give us the query you would like to improve performance?


----- Original Message ----- From: "Marco Furetto" <[EMAIL PROTECTED]>
To: <pgsql-performance@postgresql.org>
Sent: Monday, March 20, 2006 11:59 AM
Subject: [PERFORM] Query Feromance


Hello!

Can I Increment the perfomance of execution query?

Where is the instrument to analyze the query runnnig for create a Index query for a single optimize that?

thank's

Marco "Furetto" Berri

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to