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" <furetto@xxxxxxxxxxxxx>
To: <pgsql-performance@xxxxxxxxxxxxxx>
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
