Re: [PERFORM] Federated Postgresql architecture ?

2008-06-30 Thread Jonah H. Harris
On Mon, Jun 30, 2008 at 9:16 AM, Marko Kreen <[EMAIL PROTECTED]> wrote: > But I want to clarify it's goal - it is not to run "pre-determined > queries." It is to run "pre-determined complex transactions." Yes. > And to make those work in a "federated database" takes huge amount > of complexity t

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-30 Thread Marko Kreen
On 6/27/08, Chris Browne <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] (Josh Berkus) writes: > > Jonah, > > > >> Hmm, I didn't think the Skype tools could really provide federated > >> database functionality without a good amount of custom work. Or, am I > >> mistaken? > > > > Sure, what d

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-27 Thread Chris Browne
[EMAIL PROTECTED] (Josh Berkus) writes: > Jonah, > >> Hmm, I didn't think the Skype tools could really provide federated >> database functionality without a good amount of custom work. Or, am I >> mistaken? > > Sure, what do you think pl/proxy is for? Ah, but the thing is, it changes the model fr

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-26 Thread Jonah H. Harris
On Thu, Jun 26, 2008 at 6:31 PM, Josh Berkus <[EMAIL PROTECTED]> wrote: > Sure, what do you think pl/proxy is for? Well, considering that an application must be written specifically to make use of it, and for very specific scenarios, I wouldn't consider it as making PostgreSQL a federated database

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-26 Thread Josh Berkus
Jonah, > Hmm, I didn't think the Skype tools could really provide federated > database functionality without a good amount of custom work. Or, am I > mistaken? Sure, what do you think pl/proxy is for? -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco -- Sent via pgsql-performance mailing

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-26 Thread Jonah H. Harris
On Thu, Jun 26, 2008 at 5:41 PM, Josh Berkus <[EMAIL PROTECTED]> wrote: >> Not to self-plug, but if you require it, EnterpriseDB includes >> Oracle-style database links (SELECT col FROM [EMAIL PROTECTED]) which support >> predicate push-down. > > Also check out Skytools: http://skytools.projects.p

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-26 Thread Josh Berkus
Kevin, > Not to self-plug, but if you require it, EnterpriseDB includes > Oracle-style database links (SELECT col FROM [EMAIL PROTECTED]) which support > predicate push-down. Also check out Skytools: http://skytools.projects.postgresql.org/doc/ -- --Josh Josh Berkus PostgreSQL @ Sun San Franc

Re: [PERFORM] Federated Postgresql architecture ?

2008-06-26 Thread Jonah H. Harris
On Thu, Jun 26, 2008 at 4:33 PM, kevin kempter <[EMAIL PROTECTED]> wrote: > Anyone have any experiences to share per setting up a federated architecture > with PostgreSQL ? I wonder if the dblink contrib works well in a federated > scenario, specifically in the setup of the federated views which eq

[PERFORM] Federated Postgresql architecture ?

2008-06-26 Thread kevin kempter
Hi List; Anyone have any experiences to share per setting up a federated architecture with PostgreSQL ? I wonder if the dblink contrib works well in a federated scenario, specifically in the setup of the federated views which equate to a select * from the same table on each federated serv