what is the best way to access cold data on another server?

Поиск
Список
Период
Сортировка
От Amine Tengilimoglu
Тема what is the best way to access cold data on another server?
Дата
Msg-id CADTdw-yP_n1zDWPzNhBMe4z2siSoeU9rX4M7DLZCbtJfs1ThDQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: what is the best way to access cold data on another server?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: what is the best way to access cold data on another server?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
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..

В списке pgsql-general по дате отправления:

Предыдущее
От: Matthias Apitz
Дата:
Сообщение: Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [EXTERNAL] Re: PostgreSQL-12 replication failover, pg_rewindfails