| From: | David Wheeler <David(at)Wheeler(dot)net> |
|---|---|
| To: | Doug McNaught <doug(at)wireboard(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Long Query |
| Date: | 2001-08-08 20:34:12 |
| Message-ID: | Pine.LNX.4.21.0108081333030.17136-100000@theory.versive.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7 Aug 2001, Doug McNaught wrote:
> Make sure PG is logging to a file (rather than /dev/null), crank up
> the log level, and make sure the queries that PG gets are what the app
> is supposed to send.
Thanks for the suggestion - I'll do that.
As it turns out, though, our application is doing 100s of unnecessary
queries for virtually every request, and this is the root of the problem
-- not a bad PostgreSQL query. Sorry to have bothered everyone with this!
David
--
David Wheeler AIM: dwTheory
David(at)Wheeler(dot)net ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-08-08 21:41:30 | Re: Re: [GENERAL] Bug with ALTER TABLE |
| Previous Message | Joe Conway | 2001-08-08 20:25:22 | Re: Random strings |