From: | Vitaly Belman <vitalyb(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Major CPU/HD use |
Date: | 2004-08-23 20:19:23 |
Message-ID: | fa96e3c60408231319bbb5c9c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm using CoLinux (colinux.org) and PostgreSQL, every 10-20 minutes my
HD and CPU go to massive use for about 5 minutes and I am very curious
about who's causing it (I do know for sure it is coming from Linux and
not Windows).
I am no Linux expert and I quite baffled about how to get such
information in the cosole (tried 'ps' but it didn't seem to have such
information).
So the main questions:
1) Does your PostgreSQL behave the same? Or is it only my setup?
2) Is it possible that I turned autovacuum on by mistake or something
like that and it just vacuums my DB every few minutes?
3) How can I check, in console, which process in linux uses the CPU
(the way I can in Windows Task Manager).
Thanks.
--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent(at)hotmail(dot)com
Yahoo!: VitalyBe
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur van Dorp | 2004-08-23 20:30:46 | Re: Major CPU/HD use |
Previous Message | Sean Davis | 2004-08-23 11:57:25 | Re: Populating tables with data |