From: Marco Furetto <furetto@bluestudio.it>
To: pgsql-performance@postgresql.org
Subject: Re: Query Feromance
Date: Tue, 21 Mar 2006 09:25:50 +0100
Message-ID: <441FB88E.2060801@bluestudio.it> (raw)
In-Reply-To: <001301c64c3c$3404b3f0$8b00000a@reimer>
References: <441EC34D.1000901@bluestudio.it>
<001301c64c3c$3404b3f0$8b00000a@reimer>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: furetto@bluestudio.it
Subject: Re: Query Feromance
In-Reply-To: <441FB88E.2060801@bluestudio.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox