On Tue, Dec 9, 2014 at 5:46 PM, Peter Geoghegan
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/cam3swztijobp
On Fri, Dec 5, 2014 at 5:14 PM, István wrote:
> I am wondering why the root cause might be here.
My guess would be that an important text-based sort operation began to
go to disk. The external sort code (tapesort) is known to do far more
comparisons than quicksort. With text sorts, you tend to se
Hi,
We are having a really interesting problem with our Postgres 9.3 instance
in our infrastructure.
Few days ago our box started to show huge CPU spikes while the IO Wait is
negligible on the box. After a while I have installed perf and started to
monitor the Postgres master process and here is
