pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
what 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