From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pgdump slowness
Date: Thu, 12 Sep 2019 11:48:28 -0500
Message-ID: <d1f02b8c-292e-4ae1-3480-ebbc30ce8049@gmail.com> (raw)
In-Reply-To: <CAAj4MFFUk_JjCbK3yXrQGyMx0SqrOcytXitjTmKDL0ip=rm77Q@mail.gmail.com>
References: <CAAj4MFGc3voQYd850tRH5QeT=3MZ3tmz4QS2Riaz12cHU5RVWg@mail.gmail.com>
<CAG1ps1yyxE9YfYsODe0oYCJ0Ovxmk=30Oeug=TL7vbGscRvw4A@mail.gmail.com>
<CAAj4MFFUk_JjCbK3yXrQGyMx0SqrOcytXitjTmKDL0ip=rm77Q@mail.gmail.com>
IO load? Slow disks, low channel bandwidth, etc?
Is this a VM on an over-subscribed host?
On 9/12/19 10:54 AM, Dhandapani Shanmugam wrote:
> 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
> <mailto: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 <mailto: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
>
--
Angular momentum makes the world go 'round.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pgdump slowness
In-Reply-To: <d1f02b8c-292e-4ae1-3480-ebbc30ce8049@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox