Re: Seeing context switch storm with 10/13 snapshot - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Seeing context switch storm with 10/13 snapshot
Date
Msg-id 4358B39A020000250000018A@gwmta.wicourts.gov
Whole thread Raw
List pgsql-hackers
Remember the suggestion I made that PostgreSQL add the capability
to define named caches and bind specific objects to those caches?
One of the reasons Sybase recommends using such named caches
(per their performance tuning documentation) is to reduce spinlock
contention.

I don't know whether PostgreSQL would get a similar benefit, but
this discussion rang a bell, so I thought I should throw it out there
on the chance that it might be useful.

-Kevin


>>> Tom Lane <tgl@sss.pgh.pa.us>  >>>

The problem right now is not lack of ability to reproduce the
problem, it is lack of ideas how to fix it.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: collector/autovacuum after crash (8.1beta3)
Next
From: Martijn van Oosterhout
Date:
Subject: Which platforms don't HAVE_POSIX_SIGNALS?