From: | Enrico Weigelt <weigelt(at)metux(dot)de> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: investigating slow queries through pg_stat_activity |
Date: | 2005-07-03 22:28:30 |
Message-ID: | 20050703222830.GA2056@nibiru.borg.metux.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
* Dan Harris <fbsd(at)drivefaster(dot)net> wrote:
Hi,
> I've got some queries generated by my application that will, for some
> reason, run forever until I kill the pid. Yet, when I run the
> queries manually to check them out, they usually work fine.
If you can change your application, you could try to encapsulate the
queries into views - this makes logging and tracking down problems
much easier.
cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
---------------------------------------------------------------------
Realtime Forex/Stock Exchange trading powered by postgresSQL :))
http://www.fxignal.net/
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Enrico Weigelt | 2005-07-03 22:45:37 | plain inserts and deletes very slow |
Previous Message | Madison Kelly | 2005-07-02 15:20:23 | Re: B-Tree index not being used |