[PostgreSQL] SMP-PPC spinlocks in 7.2.4?

[PostgreSQL] SMP-PPC spinlocks in 7.2.4?

	Eric soroos
	Mar 13, 2003 at 4:47 pm

Tom,

If you don't mind running a slightly customized version, you might try
back-patching this fix:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/async.c.diff?r1=1.91&r2=1.91.2.1
into 7.2.4 and see if that improves matters.

I'll give that a shot.

It patched cleanly except for the version header. I've been running it for about 36 hours now with no problems. I'd say that I'm about 85% convinced that it made the difference, as I've also done some optimizations since then that reduce the database load by caching.

I'd say that this patch is a candidate for 7.2.5 if there's ever another 7.2 release.

thanks for your help.

eric

Search Discussions

Discussion Posts

Eric soroos: Tom, That's probably possible, but there are some client confidentiality issues. The linux box is a migration that's being accelerated from this issue. It has more drive, more memory, no app servers, and control of the kernel shared memory parameters. eric

Follow ups

Tom Lane: Yeah. I'm not sure that there will be another 7.2 release, but I'll pop the patch into the 7.2 CVS branch while I'm thinking about it... regards, tom lane

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 4 of 5 \| next ›

Discussion Overview

group	pgsql-general @
categories	postgresql
posted	Mar 11, '03 at 5:12p
active	Mar 13, '03 at 5:07p
posts	5
users	2
website	postgresql.org
irc	#postgresql

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[PostgreSQL] SMP-PPC spinlocks in 7.2.4?

Search Discussions

Discussion Posts

Related Discussions

2 users in discussion