Is khugepaged running during the stalls? http://www.postgresql.org/message-id/20130716195834.8fe5c79249cb2ff0d4270...@yahoo.es
Matt On Thu, Dec 5, 2013 at 7:44 AM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Thu, Dec 5, 2013 at 1:46 AM, 吕晓旭 <lxxstc...@gmail.com> wrote: >> >> >> >> Hi, all >> We find so weird problem on our productive PostgreSQL system. And I >> don't know how could I do to resolve this problem. >> We deployed PostgreSQL 9.2.4 on two system environments, and the >> performances between them are absolutely different. one of them it's >> perfect, and the other one lets me down, CPU Usage and LoadAverage Jumped up >> Suddenly when concurrency smoothly rising up, simultaneously, average >> response time become unacceptable. >> Anyone, who could give me some advice? >> >> The parameters of system environment and PotgreSQL listed below: > > Have you tried monitoring your IO subsystem when this happens? I'd be > interested in iostat, vmstat, iotop, and so on to see what the IO > looks like. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general