pgdump slowness

From: Dhandapani Shanmugam <postgresql95(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pgdump slowness
Date: 2019-09-12 15:35:42
Message-ID: CAAj4MFGc3voQYd850tRH5QeT=3MZ3tmz4QS2Riaz12cHU5RVWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message nikhil raj 2019-09-12 15:51:58 Re: pgdump slowness
Previous Message Mariel Cherkassky 2019-09-12 14:53:37 pg12 - foreign key to partitions