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:21:23 +0530
Message-ID: <20050826225123.GB24476@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
> Ligesh <gxlists@gmail.com> wrote:
> Mostly because every situation is different, you may have
> 10 servers and need 10 rows of results, others may need something
> entirely different.
>
No. I have say 'm' number of servers, and I need 'n' rows. To get the results, you need to run the query against all the 'm' servers, which will return 'm x n' results, then you have to re-sort it and drop the 'm x n - n' rows and return only the 'n'. So this is like retrieving the 'n' rows amongst ALL the servers, that satisfy your search criteria.
Once you retrieve the data, you will know which server each row belongs to, and you can do the writes yourself at the higher level.
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: <20050826225123.GB24476@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