Skip site navigation (1) Skip section navigation (2)

Re: is parallel union all possible over dblink?

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>
Cc: Marinos Yannikos <mjy(at)geizhals(dot)at>, <pgsql-performance(at)postgresql(dot)org>,Svetlin Manavski <svetlin(dot)manavski(at)gmail(dot)com>
Subject: Re: is parallel union all possible over dblink?
Date: 2011-06-29 19:38:24
Message-ID: 4E0B7F30.4090208@peak6.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 06/29/2011 02:14 PM, Greg Spiegelberg wrote:

> Another alternative is to use GridSQL. I haven't used it myself but
> seen it in action on a large install with 4 backend databases. Pretty
> slick.

We actually demoed this as a proof of concept a while back. Even just 
having two instances on the same machine resulted in linear improvements 
in execution speed thanks to parallel query execution.

Setting it up is something of a PITA, though, and the metadata database 
is completely arbitrary. You basically must use the GridSQL intermediate 
layer if you ever want to see your data again. I wouldn't use it for 
anything but a reporting database that can be reconstructed if necessary.

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas(at)peak6(dot)com

______________________________________________

See  http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email

In response to

pgsql-performance by date

Next:From: Jeff JanesDate: 2011-06-30 03:41:53
Subject: Re: sequential scan unduly favored over text search gin index
Previous:From: Greg SpiegelbergDate: 2011-06-29 19:14:32
Subject: Re: is parallel union all possible over dblink?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group