Search Postgresql Archives

Re: Major Performance decrease after some hours

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2006/10/2, Tom Lane <tgl@xxxxxxxxxxxxx>:
"Peter Bauer" <peter.m.bauer@xxxxxxxxx> 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.

Sorry, i put the files on http://dagobert.apus.co.at/pglogfiles/ so
please use them.

>> 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.

ok, i will try to reproduce it and post the stack traces

thx,
Peter


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux