How to move a separate postgres database table to another server?

Question

PostgreSQL

Let's say there is a database "DB", it is located on the server "Server1", it has a table that is under load! Write / read! "overload_table", appeared Server2 whose task is to unload the database. What are the simplest, most practical, and most efficient examples of offloading Server1?

Answer 1

First, do a load analysis.
Since the solutions can be up to the opposite.
In addition, it is not clear what kind of system you have, how much you can modify it, taking into account the work with two servers.
Offhand, one option is often used:
Operational activities are carried out on the main server. Data records.
And long-running queries, read-only, are executed on another server.
Replication between servers.
Another option:
Part of the entities on one server, and part on the other.
For example, every even post of your forum - or whatever you have - is on the first.
And every odd one on the second.
Etc.

Answer 2

Move data that is frequently accessed to a separate tablespace located on higher-performance disks, such as SSDs.