pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedwhat is the best way to access cold data on another server?
5+ messages / 4 participants
[nested] [flat]
* what is the best way to access cold data on another server?
@ 2020-05-13 07:12 Amine Tengilimoglu <aminetengilimoglu@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Amine Tengilimoglu @ 2020-05-13 07:12 UTC (permalink / raw)
To: " <pgsql-general@postgresql.org>; pgsql-admin
Hello everyone;
In addition to the actively used data, there are other data that are
very little accessed. I want to separate the less used data to save space
and reduce maintenance operations. I want to use a separate postgres
instance for this. Now the question is; How do I link these two instances?
postgres_fdw or dblink? or what other solution? Which one would be better?
thanks in advance..
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: what is the best way to access cold data on another server?
@ 2020-05-13 07:24 Holger Jakobs <holger@jakobs.com>
parent: Amine Tengilimoglu <aminetengilimoglu@gmail.com>
1 sibling, 2 replies; 5+ messages in thread
From: Holger Jakobs @ 2020-05-13 07:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
dblink is outdated, postgres_fdw is current.
Am 13.05.20 um 09:12 schrieb Amine Tengilimoglu:
> Hello everyone;
>
> In addition to the actively used data, there are other data that
> are very little accessed. I want to separate the less used data to
> save space and reduce maintenance operations. I want to use a separate
> postgres instance for this. Now the question is; How do I link these
> two instances? postgres_fdw or dblink? or what other solution? Which
> one would be better?
>
>
>
> thanks in advance..
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: what is the best way to access cold data on another server?
@ 2020-05-13 07:34 Amine Tengilimoglu <aminetengilimoglu@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
1 sibling, 0 replies; 5+ messages in thread
From: Amine Tengilimoglu @ 2020-05-13 07:34 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
I am concerned about the security of fdw. so I actually asked for its
comparison with dblink and wondered if there was any other technique to do
this.
Holger Jakobs <holger@jakobs.com>, 13 May 2020 Çar, 10:24 tarihinde şunu
yazdı:
> dblink is outdated, postgres_fdw is current.
>
> Am 13.05.20 um 09:12 schrieb Amine Tengilimoglu:
> > Hello everyone;
> >
> > In addition to the actively used data, there are other data that
> > are very little accessed. I want to separate the less used data to
> > save space and reduce maintenance operations. I want to use a separate
> > postgres instance for this. Now the question is; How do I link these
> > two instances? postgres_fdw or dblink? or what other solution? Which
> > one would be better?
> >
> >
> >
> > thanks in advance..
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: what is the best way to access cold data on another server?
@ 2020-05-13 11:35 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Amine Tengilimoglu <aminetengilimoglu@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Laurenz Albe @ 2020-05-13 11:35 UTC (permalink / raw)
To: Amine Tengilimoglu <aminetengilimoglu@gmail.com>; " <pgsql-general@postgresql.org>; pgsql-admin
On Wed, 2020-05-13 at 10:12 +0300, Amine Tengilimoglu wrote:
> In addition to the actively used data, there are other data that are very little accessed.
> I want to separate the less used data to save space and reduce maintenance operations.
> I want to use a separate postgres instance for this. Now the question is; How do I link
> these two instances? postgres_fdw or dblink? or what other solution? Which one would be better?
Foreign Data Wrapper is a good option, and yes, it is secure.
Another option would be to store these data as CSV files and use file_fdw
to define them as "external tables".
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: what is the best way to access cold data on another server?
@ 2020-05-14 15:26 Jeff Janes <jeff.janes@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
1 sibling, 0 replies; 5+ messages in thread
From: Jeff Janes @ 2020-05-14 15:26 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
On Wed, May 13, 2020 at 3:24 AM Holger Jakobs <holger@jakobs.com> wrote:
> dblink is outdated, postgres_fdw is current.
>
dblink may not be getting lots of improvements, but it is maintained to the
same standards as postgres_fdw is. FDW inhibits parallel queries, on both
sides. dblink maintains that possibility, (while tedious to do in a
useful way). Also, FDW cannot push UDF calls, while dblink can if you
manually write them into the sent query.
Cheers,
Jeff
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2020-05-14 15:26 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-13 07:12 what is the best way to access cold data on another server? Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-05-13 07:24 ` Holger Jakobs <holger@jakobs.com>
2020-05-13 07:34 ` Amine Tengilimoglu <aminetengilimoglu@gmail.com>
2020-05-14 15:26 ` Jeff Janes <jeff.janes@gmail.com>
2020-05-13 11:35 ` Laurenz Albe <laurenz.albe@cybertec.at>
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