From: | "Dmitry Koterov" <dmitry(at)koterov(dot)ru> |
---|---|
To: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Strange behaviour under heavy load |
Date: | 2007-03-27 16:34:29 |
Message-ID: | d7df81620703270934o478966cav9739801ebbcd4ac5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude that, but symptoms are the following: queries work very fast for
5-10 minutes, and after that - significant slowdown (every query, even a
simple one, works 5-10 and ever more times slower), disk write activity
grows too (but not everytime - I don't know exactli if there is a direct
correlation). 2-3 seconds, then - performance restores back to normal.
Autovacuum is turned off.
Machine has 2 processors, huge memory, fast SCSI disks.
I understand that there is too less information. Please advice what to
monitor for better problem discovering.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-03-27 16:40:28 | Re: Could not create relation: File exists error |
Previous Message | Oleg Bartunov | 2007-03-27 16:22:00 | Re: [GENERAL] Is there a shortage of postgresql skilled ops people |