Regarding db dump with Fc taking very long time to completion

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Regarding db dump with Fc taking very long time to completion
Date: 2019-08-30 09:51:36
Message-ID: CAJCZkoJVz7M0su8zX=S7okhXSC0wvzQSdbORK2Adyy6GQGO3tw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
To respected international postgresql team

I am using postgresql 11.4 version
I have scheduled logical dump job which runs daily one time at db level
There was one table that has write intensive activity for every 40 seconds
in db
The size of the table is about 88GB
Logical dump of that table is taking more than 7 hours to be completed

I need to reduce to dump time of that table that has 88GB in size

Regards
Durgamahesh Manne

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2019-08-30 10:41:24 Re: Regarding db dump with Fc taking very long time to completion
Previous Message Luca Ferrari 2019-08-30 08:02:35 Re: literal vs dynamic partition constraint in plan execution