From: | "Peter Bauer" <peter(dot)m(dot)bauer(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Major Performance decrease after some hours |
Date: | 2006-10-02 10:39:23 |
Message-ID: | 764c9e910610020339w11375846webcd812f203e9e1a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2006/10/2, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "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.
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
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2006-10-02 11:10:43 | Re: PostgreSQL 8.1 - SSL:Required |
Previous Message | Andrew | 2006-10-02 09:49:53 | PostgreSQL 8.1 - SSL:Required |