Re: does postgresql works on distributed systems? - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: does postgresql works on distributed systems?
Date
Msg-id 65937bea0806040800q530c1d4aiaca2b31fea777319@mail.gmail.com
Whole thread Raw
In response to Re: does postgresql works on distributed systems?  (Volkan YAZICI <yazicivo@ttmail.com>)
Responses Re: does postgresql works on distributed systems?  (Volkan YAZICI <yazicivo@ttmail.com>)
List pgsql-general
On Wed, Jun 4, 2008 at 11:34 AM, Volkan YAZICI <yazicivo@ttmail.com> wrote:
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

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Mediawiki 1.10 and PG 8.3 upgrade
Next
From: "Kynn Jones"
Date:
Subject: pg_restore frozen?