Re: pgdump slowness

Поиск
Список
Период
Сортировка
От Dhandapani Shanmugam
Тема Re: pgdump slowness
Дата
Msg-id CAAj4MFFUk_JjCbK3yXrQGyMx0SqrOcytXitjTmKDL0ip=rm77Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgdump slowness  (nikhil raj <nikhilraj474@gmail.com>)
Ответы Re: pgdump slowness
Список pgsql-admin
Hi Nikhil,

I don't see any resource issues on server. the cpu shows 90% idle and the load of the server is very normal. I am using 6 parallel process. 

-D

On Thu, Sep 12, 2019 at 9:22 PM nikhil raj <nikhilraj474@gmail.com> wrote:
Hi Dhandapani,

That is the system  configuration and version  and how many parallel job you are running in the command. 

Please let know the details.

On Thu, 12 Sep 2019, 9:05 pm Dhandapani Shanmugam, <postgresql95@gmail.com> wrote:
Hi Guys,

We are having wired issue. pg_dump taking more time to backup 320 GB of table,the table has bytea data type with TOAST table associated it. Please let me know, if this is the expected behavior of pg_dump or do i need to tune any of the parameters.  I tried to run pg_dump with parallel -j option , still no improvement and there is no lock on the table as well. any inputs are welcome

-D

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: pgdump slowness
Следующее
От: Ron
Дата:
Сообщение: Re: pgdump slowness