I'm planning to make a survey regarding PostgreSQL performance on
OpenSSI. There are some obstacles mostly caused by shared-memory
architecture of PostgreSQL, but that claim is -- AFAIK -- totally
theoratical. There aren't any benchmarks done yet that explains
shared-memory bottlenecks of PostgreSQL on an OpenSSI framework. If
anybody have experience with PostgreSQL on OpenSSI, I'll be happy to
hear them. (Yeah, there were some related posts in the past; but they
were mostly noise.)
If you search for OpenSSI Postgres, you hit this link:
http://wiki.openssi.org/go/PostgreSQL_on_OpenSSI_enabled_Knoppix
I have done this setup and small test on it about an year ago. The performance was horrible. I cannot say for sure, but I think, as OpenSSI FAQ mentions it, it's because of the way Postgres works with shared memory.
I hope you find that article useful in starting your own experiment. Lets hope there's some improvement since last year. Do let us all know the results.
Best regards,
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
