Re: I'd like to discuss scaleout at PGCon - Mailing list pgsql-hackers

From Haribabu Kommi
Subject Re: I'd like to discuss scaleout at PGCon
Date
Msg-id CAJrrPGe9Q3PWU5oxWXe5Yxt_TkzXzQMRMq3-tpzdUb5ZcGOdCA@mail.gmail.com
Whole thread Raw
In response to Re: I'd like to discuss scaleout at PGCon  (Bruce Momjian <bruce@momjian.us>)
Responses Re: I'd like to discuss scaleout at PGCon
List pgsql-hackers

On Sat, Jun 23, 2018 at 12:17 PM Bruce Momjian <bruce@momjian.us> wrote:
On Fri, Jun 22, 2018 at 01:28:58PM -0500, Merlin Moncure wrote:
> On Fri, Jun 22, 2018 at 12:34 PM Bruce Momjian <bruce@momjian.us> wrote:
> >
> > What we don't want to do is to add a bunch of sharding-specific code
> > without knowing which workloads it benefits, and how many of our users
> > will actually use sharding.  Some projects have it done that, and it
> > didn't end well since they then had a lot of product complexity with
> > little user value.
>
> Key features from my perspective:
> *) fdw in parallel.  how do i do it today? ghetto implemented parallel
> queries with asynchronous dblink

Andres has outlined what needs to be done here:

        https://www.postgresql.org/message-id/20180525033538.6ypfwcqcxce6zkjj%40alap3.anarazel.de 

Sorry if this was already been discussed in up-thread.

Just I would like to bring out idea scale out by adding many instances that
can share the lock and buffer pool manager with all the instances with
the help of Remote direct memory access.

By adding pluggable buffer pool and lock manager, how about adding
many instances and all share the buffers using RDMA to provide
better scaling with shared everything.

Currently I didn't know have any idea whether is it possible or not and also
the problems in using RDMA. 

Just want to check whether is it worth idea to consider in supporting scale out?

Regards,
Haribabu Kommi
Fujitsu Australia

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: I'd like to discuss scaleout at PGCon
Next
From: Bruce Momjian
Date:
Subject: Re: SCRAM with channel binding downgrade attack