| From: | Florian Weimer <fweimer(at)bfk(dot)de> |
|---|---|
| To: | Christopher Opena <counterveil(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Puzzling full database lock |
| Date: | 2012-02-02 14:11:55 |
| Message-ID: | 82obth2ul0.fsf@mid.bfk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Christopher Opena:
> We've been running into some very strange issues of late with our
> PostgreSQL database(s). We have an issue where a couple of queries push
> high CPU on a few of our processors and the entire database locks (reads,
> writes, console cannot be achieved unless the high CPU query procs are
> killed).
Does the kernel log something? Does "dmesg" display anything
illuminating?
--
Florian Weimer <fweimer(at)bfk(dot)de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2012-02-02 14:23:40 | Re: Is it possible to speed up addition of "not null"? |
| Previous Message | Florian Weimer | 2012-02-02 14:08:51 | Re: Is it possible to speed up addition of "not null"? |