Re: pg_replication_slots

2017-11-29 Thread Emanuel Alvarez
restart_lsn) FROM pg_replication_slots; pg_current_xlog_location() will give you the actual log location in master, and you can get all info about a slot in the pg_replication_slots relation. In this case we query for restart_lsn which has the slot restart location. pg_xlog_location_diff() is

pg_replication_slots

2017-11-29 Thread Nicola Contu
Hello, I just have few questions on the replication slots : - is it possible to get size of the slot? - if the slave is down, the table grows, when the slave comes up again, will the table be flushed after pushing wals? - will they impact performances on the master? I'm just worried about the siz