Re: Opportunity for a Radical Changes in Database Software - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Opportunity for a Radical Changes in Database Software
Date
Msg-id 36e682920710250822n48e55423g6696773b3b8545e6@mail.gmail.com
Whole thread Raw
In response to Opportunity for a Radical Changes in Database Software  (Dan <dss01Card-Offer@prestohosting.com>)
List pgsql-hackers
I'd suggest looking at the source code to several of the in-memory
databases which already exist.

On 10/25/07, Dan <dss01Card-Offer@prestohosting.com> wrote:
> Hi
>
> In looking at current developments in computers, it seems we're nearing
> a point where a fundamental change may be possible in databases...
> Namely in-memory databases which could lead to huge performance
> improvements.
>
> A good starting point is to look at memcached, since it provides proof
> that it's possible to interconnect hundreds of machines into a huge
> memory cluster with, albeit, some issues on reliability.
>
> For more info on memcached, try:
> http://www.socialtext.net/memcached/index.cgi?faq
>
> The sites that use it see incredible performance increases, but often at
> the cost of not being able to provide versioned results that are
> guaranteed to be accurate.
>
> The big questions are then, how would you create a distributed in-memory
> database?
>
>
> Another idea that may be workable
>
> Everyone knows the main problem with a standard cluster is that every
> machine has to perform every write, which leads to diminishing returns
> as the writes consume more and more of every machine's resources. Would
> it be possible to create a clustered environment where the master is the
> only machine that writes the data to disk, while the others just use
> cached data? Or, perhaps it would work better if the master or master
> log entry moves from machine to machine with a commit coinciding with a
> disk write on each machine?
>
> Any other ideas?  It seems to be a problem worth pondering since
> in-memory databases are possible.
>
> Thanks
>
> Dan
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>


-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah.harris@enterprisedb.com
Edison, NJ 08837                        | http://www.enterprisedb.com/


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Datum should be defined outside postgres.h
Next
From: Tom Lane
Date:
Subject: Re: Datum should be defined outside postgres.h