From: Ligesh <gxlists@gmail.com>
To: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sending a select to multiple servers.
Date: Sat, 27 Aug 2005 04:15:40 +0530
Message-ID: <20050826224540.GA24476@lxlabs.com> (raw)
In-Reply-To: <20050826110459.03cce4d9.frank@wiles.org>
References: <20050826152409.GA22060@lxlabs.com>
<20050826110459.03cce4d9.frank@wiles.org>
On Fri, Aug 26, 2005 at 11:04:59AM -0500, Frank Wiles wrote:
> On Fri, 26 Aug 2005 20:54:09 +0530
> This is typically handled by the application layer, not a standard
> client. Mostly because every situation is different, you may have
> 10 servers and need 10 rows of results, others may need something
> entirely different.
>
> This isn't really a "cluster" either. In a clustered environment
> you would send the one query to any of the 10 servers and it would
> return the proper results.
>
> But like I said this type of application is fairly trivial to write
> in most scripting or higher level languages.
>
The cluster logic is sort of implemented by this client library. If you write this at higher level the scalability becomes an issue. For 10 servers it is alright. If you want to retrieve 100 rows, and there are 100 servers, you will have a total result set of 10,000, which should be re-sorted and the 9900 of them should be droped, and only the 100 should be returned.
Anyway, what I want to know is, if there is such a functionality offered by some C library.
Thanks.
--
:: Ligesh :: http://ligesh.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gxlists@gmail.com, frank@wiles.org
Subject: Re: Sending a select to multiple servers.
In-Reply-To: <20050826224540.GA24476@lxlabs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox