On 7/26/22 08:15, Rama Krishnan wrote:
Hi Adrian


ThanksĀ for your reply,

My actual db size was 320G while I am taking custom format and moving into directly S3 it took more than one day so I am trying to use directory format becauseĀ  parllel option (-j option) supports ik directory format.

Is the database in AWS also or is it locally hosted?

In either case what is the network distance that the data has to cross?

What is the network speed of the slowest link?


What is size of table?

I m having two Database example

01. Cricket 320G
02.badminton 250G

So you are talking about an entire database not a single table, correct?


What sort of time interval are you seeing?

I am doing purge data to keep 1 year data n db more than year data I am going yo take dump backup for future reports purpose.

What problem is it causing?

The normal custom format backup took more than day



--
Adrian Klaver
adrian.kla...@aklaver.com


  • [no subject] Rama Krishnan
    • Re: Adrian Klaver
      • Re: Rama Krishnan
        • Re: Adrian Klaver
          • Re: Ron
            • Re: Adrian Klaver
              • Re: hubert depesz lubaczewski
                • Re: Alicja Kucharczyk

Reply via email to