11.07.2013 2:07, unordained wrote:

> For the most part, things are okay, but when nbackup is running (level-2
> backups
> every hour, takes about 10 minutes), I'm seeing something I haven't
> historically
> seen: concurrent queries take enormously longer to complete than usual.
> I'm used
> to a little bump in the average with no significant outliers, but now
> I'm seeing
> stuff hang as long as 4 or 5 minutes, that used to maybe take 200ms
> extra during
> backups. Once the backup is finished, it all goes back to normal. It
> doesn't
> seem to force queries to wait until the backup is finished, it just
> delays them
> a lot. (Doesn't seem to be right when it merges the delta file back in,
> which
> I've noticed before does tend to nearly freeze everything.) I see
> slowness in
> getting connections / starting transactions, in reads, writes... it's
> not just
> one aspect.

Out of curiosity, did you try playing with -D ON/OFF modes for nbackup?
If so, does it make any difference?


Dmitry