I'm running postgreSQL 9.6.0 on CentOS 7.2. Occasionally I need to shift data on to a larger tablespace to prevent
/var from filling up. When this is running the
pg_xlog directory grows rapidly, and recovers very slowly. Periodic
CHECKPOINT's subsequently help to kick the xlog clean up into action. However, this laborious severely limits the amount of data I can shift in a short space of time. Upgrades and restarts are very tricky since the database records continuous long running collections from various data sources.
My gut feeling is that
SET TABLESPACE prevents updates from WAL being committed, but this doesn't make much sense...
Any help or insight greatly appreciated!