Query preformence

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: pgsql-patches(at)postgresql(dot)org
Subject: Query preformence
Date: 2001-11-07 09:58:01
Message-ID: 200111071000.fA7A0sd19090@server9.telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,

We try to migrate from mysql to postgres 7.2 (Debian). In mysql we use
"slow-query-logging" to improve the preformance of our query's.
This is a very important for us.

In postgres there is no relationship between de debug_print_query and the
show_query_stats, so you can't monitor the query preformance.

Is someone already solving this problem (i'ts on de to-do list) ?

I've made a simple change (i'm a newbe) in the src/backend/tcop/postgres.c.
I don't now if it's good enough, but it solves my problems.

Yours,
Ferdinand Smit (ferdinand(at)telegraafnet(dot)nl)

Attachment Content-Type Size
postgres.diff.gz application/x-gzip 606 bytes

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-11-07 17:07:22 Re: Query preformence
Previous Message Bruce Momjian 2001-11-07 03:09:11 Re: Update: nls-ru-libpq-20011104-1449.tar.gz