Re: Query Feromance

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@bluestudio.it>
> 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
>
>