Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup/Restore too slow - Mailing list pgsql-performance

From Tom Lane
Subject Re: Backup/Restore too slow
Date
Msg-id 14012.1167414246@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backup/Restore too slow  (Rod Taylor <rod.taylor@gmail.com>)
Responses Re: Backup/Restore too slow  (Sebastián Baioni <sebaioni-postgresql@yahoo.com.ar>)
List pgsql-performance
Tree view 
Rod Taylor <rod.taylor@gmail.com> writes:
> Rebuilding the indexes or integrity confirmations are probably taking
> most of the time.

> What is your work_mem setting?

maintenance_work_mem is the thing to look at, actually.  I concur that
bumping it up might help.

            regards, tom lane

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: What you would consider as heavy traffic?
Next
From: Sebastián Baioni
Date:
Subject: Re: Backup/Restore too slow