Re: General DB Tuning

Yes, that is exactly what I want to use!

Unfortunately, it doesn't work if you access postgres
through a JDBC connection. I don't know why. I found
a posting from back in February which talks aobut this
a little:

http://archives.postgresql.org/pgsql-admin/2005-02/msg00055.php

But I can't find anywhere where someone has fixed it.
Am I the only one accessing postgres through JDBC?

-Brent

--- Tom Arthurs <tarthurs(at)jobflash(dot)com> wrote:

> I have this in my postgresql.conf file and it works
> fine (set the min to
> whatever you want to log)
> log_min_duration_statement = 3000 # -1 is disabled,
> in milliseconds.
>
> Another setting that might get what you want:
>
> #log_duration = false
>
> uncomment and change to true.
>
> From the docs:
>
(http://www.postgresql.org/docs/8.0/interactive/runtime-config.html)
>
> Causes the duration of every completed statement
> which satisfies
> log_statement to be logged. When using this option,
> if you are not using
> syslog, it is recommended that you log the PID or
> session ID using
> log_line_prefix so that you can link the statement
> to the duration using
> the process ID or session ID. The default is off.
> Only superusers can
> change this setting.
>
> Brent Henry wrote:
> > Help! After recently migrating to Postgres 8,
> I've
> > discovered to my horror that I can't determine
> which
> > queries are poorly performing anymore because the
> > logging has drastically changed and no longer
> shows
> > durations for anything done through JDBC.
> >
> > So I'm desperately trying to do performance tuning
> on
> > my servers and have no way to sort out which
> > statements are the slowest.
> >
> > Does anyone have any suggestions? How do you
> > determine what queries are behaving badly when you
> > can't get durations out of the logs?
> >
> > I have a perl script that analyzes the output from
> > Postgres 7 logs and it works great! But it relies
> on
> > the duration being there.
> >
> > I did some searches on postgresql.org mailing
> lists
> > and have seen a few people discussing this
> problem,
> > but noone seems to be too worried about it. Is
> there
> > a simple work-around?
> >
> > Sincerely,
> >
> > Brent
> >
> >
> >
> >
> ____________________________________________________
> > Sell on Yahoo! Auctions – no fees. Bid on great
> items.
> > http://auctions.yahoo.com/
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 5: don't forget to increase your free space
> map settings
> >
> >
> >
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com