Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding db dump with Fc taking very long time to completion - Mailing list pgsql-general

From Imre Samu
Subject Re: Regarding db dump with Fc taking very long time to completion
Date
Msg-id CAJnEWwkRdJ6cQ2o0jKAD1ktae9XY+PSR7DDWr1aEgcG=_iKdPg@mail.gmail.com
Whole thread Raw
In response to Regarding db dump with Fc taking very long time to completion  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
List pgsql-general
Tree view
Hi,

Maybe - you can re-use this backup tricks.

for example:
"""
Idea was: All these tables had primary key based on serial. We could easily get min and max value of the primary key column, and then split it into half-a-million-ids “partitions", then dump them separately using:
psql -qAt -c "COPY ( SELECT * FROM TABLE WHERE id BETWEEN x AND y) TO STDOUT" | gzip -c - > TABLE.x.y.dump
"""

best,
Imre



Durgamahesh Manne <maheshpostgres9@gmail.com> ezt írta (időpont: 2019. aug. 30., P, 11:51):
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



pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: A little confusion about JSON Path
Next
From: Sonam Sharma
Date:
Subject: Analyze and vaccum