From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Peter Bauer" <peter(dot)m(dot)bauer(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Major Performance decrease after some hours |
Date: | 2006-10-02 02:43:14 |
Message-ID: | 26610.1159756994@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Peter Bauer" <peter(dot)m(dot)bauer(at)gmail(dot)com> writes:
> Attached you can find the postgresql logfiles and a logfile which
> contains alls SQL statements executed in the relevant time together
> with the excpetions thrown. I also attached a file with all used
> Pl/pgSQL functions. Since we were not able to find a problem for so
> long, i think it makes no sense to filter the information because we
> are probably not looking on the right spots.
I hope the pgsql-general moderators are not going to approve an 8MB
message :-(. I'll hang onto my copy though, just in case it proves
useful.
>> It might be worth attaching to a few of them with
>> gdb to get stack traces,
> Should this be done when the problems are appearing or during normal
> operation or both to compare the results?
When the problems are appearing.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Anibal David Acosta F. | 2006-10-02 02:47:27 | using float4, I get incorrect value when select |
Previous Message | Tom Lane | 2006-10-02 02:14:28 | Re: Normal vs Surrogate Primary Keys... |