Re: PG_Base Backup take 8 to 9Hrs

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: PG_Base Backup take 8 to 9Hrs
Дата
Msg-id 20220208130225.kbecwy3oxvfi6iuk@jrouhaud
обсуждение исходный текст
Ответ на PG_Base Backup take 8 to 9Hrs  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
Ответы Re: PG_Base Backup take 8 to 9Hrs  ("MichaelDBA@sqlexec.com" <michaeldba@sqlexec.com>)
Список pgsql-admin
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.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Ram Pratap Maurya
Дата:
Сообщение: PG_Base Backup take 8 to 9Hrs
Следующее
От: Ron
Дата:
Сообщение: Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.