| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "657985552(at)qq(dot)com" <657985552(at)qq(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: what change in postgres 9.5 improvements for multi-CPU machines |
| Date: | 2016-03-25 13:37:52 |
| Message-ID: | CAHyXU0zgU-CLbLzF_qi969EYE+C6amfT5KhtzmsJOKfQ1cpgzw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 25, 2016 at 5:11 AM, 657985552(at)qq(dot)com <657985552(at)qq(dot)com> wrote:
> hello everyone:
> I was bothered by the postgres spinlock for a long time . How to
> understand this sentence "postgres 9.5 performance improvements for
> multi-CPU machines"
> at present my database is 9.3.5 。 Can it solve the spinlock problem, if
> upgrade it to 9.5 ?
What problem? Spinlock contention is a symptom, not a problem in and
of itself. Spinlocks are good target for micro-optimization though,
and we're always looking for strategies to make things work better
if/when we get into high contention scenarios.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2016-03-25 14:18:21 | Re: Way to get at parsed trigger 'WHEN' clause expression? |
| Previous Message | 657985552@qq.com | 2016-03-25 10:11:21 | what change in postgres 9.5 improvements for multi-CPU machines |