Re: PG_Base Backup take 8 to 9Hrs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Use pgbackrest instead

Sent from my iPhone

> On Feb 8, 2022, at 8:02 AM, Julien Rouhaud <rjuju123@xxxxxxxxx> wrote:
> 
> Hi,
> 
> Please don't try to recall messages sent on a mailing list.  That won't work
> and will spam everyone.
> 
>> On Tue, Feb 08, 2022 at 11:36:19AM +0000, Ram Pratap Maurya wrote:
>> 
>> We are using Postgres -11 version and current PG DB size is 450 GB .
>> 
>> Archive log enable in Database and we are running Full PG_Base backup and it
>> will take 8 to 9 Hrs to complete the backup ,
>> 
>> Please suggest  how to reduce the full DB backup time.
> 
> That's ~16MB/s, so many times slower than a single old 7200RPM drive.  The
> problem is likely not with postgres, you should get a better storage or a
> better network.
> 
> 







[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux