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
In response to
pgsql-performance by date
|Next:||From: Sebastián Baioni||Date: 2006-12-29 18:03:55|
|Subject: Re: Backup/Restore too slow |
|Previous:||From: Rod Taylor||Date: 2006-12-29 17:32:39|
|Subject: Re: What you would consider as heavy traffic?|