Query preformence - Mailing list pgsql-patches

From Ferdinand Smit
Subject Query preformence
Date
Msg-id 200111071000.fA7A0sd19090@server9.telegraafnet.nl
Whole thread Raw
Responses Re: Query preformence  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@telegraafnet.nl)



Attachment

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Update: nls-ru-libpq-20011104-1449.tar.gz
Next
From: Tom Lane
Date:
Subject: Re: Query preformence