Re: Query Feromance

From: Marco Furetto
Subject: Re: Query Feromance
Date: ,
Msg-id: 441FB88E.2060801@bluestudio.it
(view: Whole thread, Raw)
In response to: Re: Query Feromance  ("Reimer")
Responses: Re: Query Feromance  (Thomas Pundt)
List: pgsql-performance

Tree view

Query Feromance  (Marco Furetto, )
 Re: Query Feromance  ("Reimer", )
  Re: Query Feromance  (Marco Furetto, )
   Re: Query Feromance  (Thomas Pundt, )
    Re: Query Feromance  (Marco Furetto, )
     Re: Query Feromance  (Thomas Pundt, )
    Re: Query Feromance  (Marco Furetto, )

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" <>
> To: <>
> 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
>
>



pgsql-performance by date:

From: "Merlin Moncure"
Date:
Subject: Re: update == delete + insert?
From: Guillaume Cottenceau
Date:
Subject: Re: Postmaster using only 4-5% CPU