Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.

From: Christopher Browne <cbbrowne(at)gmail(dot)com>
To: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.
Date: 2018-10-11 03:11:01
Message-ID: CAFNqd5V5LsD-JeSmJAe1tJt6Z4-a-fDmgKTB789sDi78FTN+Zg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 10, 2018, 10:32 PM Raghavendra Rao J S V <
raghavendrajsv(at)gmail(dot)com> wrote:

> Hi All,
>
> pg_dump is taking more time. Please let me know which configuration
> setting we need to modify to speedup the pg_dump backup.We are using 9.2
> version on Centos Box.
>

There certainly isn't a configuration parameter to say "make PG dump
faster."

- It is possible that it is taking longer to backup the database because
the database has grown in size. If you have a lot more data captured, this
would be a natural consequence, that you need simply to accept.

But there are additional possibilities...

- Perhaps the database is bloated because an update pattern is leading to a
lot of dead data being left behind. In that case some tables need to be
vacuumed much more often and you should look into the auto vacuum
configuration.

- Perhaps the database has some table that contains a lot of obsolete
data. This would depend heavily on the nature of your application.

You should look to see what data you are collecting that is not of ongoing
value. That may represent data that you should trim out of the database.
That should improve the amount of time it takes to do a backup of the
database.

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra Rao J S V 2018-10-11 03:14:08 Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.
Previous Message Ron 2018-10-11 02:42:29 Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup.