Re: [HACKERS] spinlocks storm bug

2013-12-06 Thread Pavel Stehule
2013/12/6 Andres Freund > On 2013-12-06 07:22:27 +0100, Pavel Stehule wrote: > > I have a report of critical bug (database is temporary unavailability .. > > restart is necessary). > > > PostgreSQL 9.2.4, > > 24 CPU > > 140G RAM > > SSD disc for all > > > > > > Database is under high load. There

Re: [HACKERS] spinlocks storm bug

2013-12-06 Thread Andres Freund
On 2013-12-06 07:22:27 +0100, Pavel Stehule wrote: > I have a report of critical bug (database is temporary unavailability .. > restart is necessary). > PostgreSQL 9.2.4, > 24 CPU > 140G RAM > SSD disc for all > > > Database is under high load. There is a few databases with very high number > of

[HACKERS] spinlocks storm bug

2013-12-05 Thread Pavel Stehule
Hello I have a report of critical bug (database is temporary unavailability .. restart is necessary). A customer use: PostgreSQL 9.2.4, 24 CPU 140G RAM SSD disc for all Database is under high load. There is a few databases with very high number of similar simple statements. When application p