Re: [HACKERS] RFC: remote tables feature

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
Cc: PostgreSQL Hacker <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] RFC: remote tables feature
Date: 1999-07-23 04:21:02
Message-ID: 3797EDAE.B6A3AC12@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> So, am I completely nuts, or is this a possibility?

I've thought about this a bit too. Seems like it would be fun to try.
My old Ingres installation had a separate distributed server running
between the client and the actual table server, and perhaps the
Postgres backend could be taught to do this too. Perhaps you could
replace the file manager (for a specific table) with something using
the SPI interface to query a remote table. Don't know if there would
be deadlock problems if you came into a table from two different
directions on the same query though...

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 1999-07-23 04:33:28 Re: [PORTS] RedHat6.0 & Alpha
Previous Message Thomas Lockhart 1999-07-23 03:33:36 Re: [HACKERS] Phantom row from aggregate in self-join in 6.5