| 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: | Whole Thread | Raw Message | 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 |
| 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 |