Re: Weird CPU utilization patterns with Postgres

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: István <leccine(at)gmail(dot)com>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Weird CPU utilization patterns with Postgres
Date: 2014-12-10 02:06:13
Message-ID: CAEYLb_Uapwtxdv+f3suZa5hN34AxaNhcq8mFe1zksCzGHYyJ2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 9, 2014 at 5:46 PM, Peter Geoghegan
<peter(dot)geoghegan86(at)gmail(dot)com> wrote:
> I'm currently trying to fix this across the board [1], but my first
> suggestion is to try enabling log_temp_files to see if external sorts
> can be correlated with these stalls.

See also: http://www.postgresql.org/message-id/CAM3SWZTijoBPpqFF7mN3021Vvtu+5Fd1ymABQ8tLoV4zhfAqxA@mail.gmail.com

--
Regards,
Peter Geoghegan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2014-12-10 03:05:44 Re: Idle Sessions inTransaction with RELEASE_EXEC_SVP queries and locks
Previous Message Peter Geoghegan 2014-12-10 01:46:06 Re: Weird CPU utilization patterns with Postgres