Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Backup/Restore too slow
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Rod Taylor <rod(dot)taylor(at)gmail(dot)com>
- Cc: Sebastián Baioni <sebastianbaioni(at)yahoo(dot)com(dot)ar>, Performance PostgreSQL <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Backup/Restore too slow
- Date: Fri, 29 Dec 2006 12:44:06 -0500
Rod Taylor <rod(dot)taylor(at)gmail(dot)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
- Follow-Ups:
- Re: Backup/Restore too slow
- From: Sebastián Baioni
- Re: Backup/Restore too slow
- References:
- Backup/Restore too slow
- From: Sebastián Baioni
- Re: Backup/Restore too slow
- From: Rod Taylor
- Backup/Restore too slow
- Prev by Date: Re: What you would consider as heavy traffic?
- Next by Date: Re: Backup/Restore too slow
- Previous by thread: Re: Backup/Restore too slow
- Next by thread: Re: Backup/Restore too slow
- Indexes: