RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.

Поиск
Список
Период
Сортировка
От Ram Pratap Maurya
Тема RE: PostgreSQL Full Vacuum Taking 5 to 6 hrs.
Дата
Msg-id KL1PR0601MB44339FD28B5E47B77799B42AF02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-admin
Hi Julien,

we are running VACUUM FULL on all table and its take 5 to 6 Hrs.



Regards,
Ram Pratap.

-----Original Message-----
From: Julien Rouhaud [mailto:rjuju123@gmail.com]
Sent: 08 February 2022 12:23
To: Ram Pratap Maurya
Cc: 'pgsql-admin@lists.postgresql.org'; Ashish Chugh
Subject: Re: PostgreSQL Full Vacuum Taking 5 to 6 hrs.

Hi,

On Tue, Feb 08, 2022 at 06:25:01AM +0000, Ram Pratap Maurya wrote:
>
> We are using Postgres -11 version and when we running Full vacuum it
> will take 5 to 6 Hrs to complete full vacuum.

What do you mean by "full vacuum" exactly?  Is it a plain VACUUM FULL?  If yes, on all tables or only some specific
ones?



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

Предыдущее
От: Nikhil Shetty
Дата:
Сообщение: Re: Lost replication slots after pg_upgrade.
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Lost replication slots after pg_upgrade.