postgres large database backup - Search results , p.2

MVCC in PostgreSQL — 6. Vacuum

database: reports running for hours will not let updated tables be duly vacuumed. Creation of a separate replica for reporting purposes may be a possible solution to this. After completion of an open transaction

What is Baked in the Baker's Dozen?

backup by the pg_basebackup utility, respectively. Optimization Evaluation of immutable functions in the FROM clause during planning The patch by Alexander Kuzmenkov and Alexandr Parfenov (both from Postgres Professional) helps when the FROM clause