| From: | nobody nowhere <devnull(at)mail(dot)ua> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Claudio Freire <klaussfreire(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: SMP on a heavy loaded database FIXED !!!! |
| Date: | 2013-01-07 18:10:17 |
| Message-ID: | 1357582217.586251208@f128.mail.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Fixed by
synchronous_commit = off
Суббота, 5 января 2013, 12:53 +04:00 от nobody nowhere <devnull(at)mail(dot)ua>:
> > > [ all postgres processes seem to be pinned to CPU 14 ]
> >
> > I wonder whether this is a "benefit" of sched_autogroup_enabled?
> >
> > http://archives.postgresql.org/message-id/50E4AAB1.9040902@optionshouse.com
> >
> > regards, tom lane
>
> Thanks Lane
>
> RHEL 5.x
> :(
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-01-07 18:27:38 | Re: [PERFORM] Slow query: bitmap scan troubles |
| Previous Message | Simon Riggs | 2013-01-07 18:03:37 | Re: [PERFORM] Slow query: bitmap scan troubles |