Re: Puzzling full database lock
| От | Carlos Mennens |
|---|---|
| Тема | Re: Puzzling full database lock |
| Дата | |
| Msg-id | CAAQLLO4MzKOAA3fLE=dJp6yprtH4OE=k0FyX6NgyTGcLuY7U3w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Puzzling full database lock (Christopher Opena <counterveil@gmail.com>) |
| Ответы |
Re: Puzzling full database lock
Re: Puzzling full database lock |
| Список | pgsql-general |
On Wed, Feb 1, 2012 at 7:38 PM, Christopher Opena <counterveil@gmail.com> wrote: > Hello folks, > > 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). Further > investigation shows ~59% total cpu usage (we have 16 total cores), low io, > and mid-to-low memory usage (we have 74GB of memory, shared_buffers=16GB). Just out of curiosity, what OS are you running?
В списке pgsql-general по дате отправления: