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

Thank you very much for your prompt response Christopher.

On Thu 11 Oct, 2018, 8:41 AM Christopher Browne, <cbbrowne(at)gmail(dot)com> wrote:

> 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.
>
>>