pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Trying to create multi db query in one large queries
Date: Wed, 15 Dec 2004 23:22:15 -0500
Message-ID: <m3fz2650ug.fsf@knuth.knuth.cbbrowne.com> (raw)
References: <41BE4598.2040708@mimos.my>
	<200412132318.24052.josh@agliodbs.com>

The world rejoiced as josh@agliodbs.com (Josh Berkus) wrote:
> Hasnul,
>
>> My question is if there is a query design that would query multiple
>> server simultaneously.. would that improve the performance?
>
> Not without a vast amounts of infrastructure coding.  You're
> basically talking about what Oracle has spent the last 3 years and
> $100 million working on.

I recall a presentation from folks from Empress Software
<http://www.empress.com/; back in about '94 or '95 offering this very
feature as part of the "base functionality" of their product.

I'm not sure it's quite fair to assess things as "more or less
preposterous" simply because they prove ludicrously expensive to
develop on a particular platform that happens to be targeted by even
more ludicrous quantities of development dollars...

On the other hand, it seems unlikely that "improved performance" would
be one of the merits of this approach...
-- 
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/
Rules of the  Evil Overlord #92.  "If I  ever talk to  the hero on the
phone, I  will  not taunt him.  Instead  I  will  say that  his dogged
perseverance has given me new insight on the futility  of my evil ways
and that if he leaves me alone for a few months of quiet contemplation
I will   likely  return to  the  path  of righteousness.   (Heroes are
incredibly gullible in this regard.) <http://www.eviloverlord.com/;



view thread (5+ messages)

Message-ID: <m3fz2650ug.fsf@knuth.knuth.cbbrowne.com>
Permalink:  ../m3fz2650ug.fsf@knuth.knuth.cbbrowne.com/
Also on:    postgresql.org/message-id/m3fz2650ug.fsf@knuth.knuth.cbbrowne.com

 · 

reply

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: cbbrowne@acm.org
  Subject: Re: Trying to create multi db query in one large queries
  In-Reply-To: <m3fz2650ug.fsf@knuth.knuth.cbbrowne.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