From: | Sergey Samokhin <prikrutil(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | How do I store tables on a remote host? |
Date: | 2009-09-04 00:10:33 |
Message-ID: | e42595410909031710g51ca017fr310339c23e7755bf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello.
Is this possible to move a table from one machine to another and then
redirect queries involving this table to the remote host in a
transparent way?
As I have just read, tablespaces let us define where given tables
should be stored on the file system. What I'm looking for is like
tablespaces, but with the ability to use a remote host as location.
Although it of course will make any queries that need remote tables to
look at slower, I think it's a good idea to move, say, old fragments
of table containing log entries to remote machines.
An exotic idea to use both remote file systems and tablepaces has just
come to my mind, but I have a feel that there may be an analouge built
into PG.
Thanks.
--
Sergey Samokhin
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2009-09-04 00:10:44 | Re: column level, uid based authorization to update columns |
Previous Message | Christopher Condit | 2009-09-03 23:21:48 | Re: query speed question |