From: | Marco Furetto <furetto(at)bluestudio(dot)it> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Query Feromance |
Date: | 2006-03-21 08:25:50 |
Message-ID: | 441FB88E.2060801@bluestudio.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)bluestudio(dot)it>
> To: <pgsql-performance(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Pundt | 2006-03-21 08:43:57 | Re: Query Feromance |
Previous Message | Amit Soni | 2006-03-21 05:59:54 | Perfomance test figures |