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.klaver@aklaver.com