Skip site navigation (1) Skip section navigation (2)

Re: transaction delays to apply

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nickolay <nitro(at)zhukcity(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: transaction delays to apply
Date: 2009-08-12 21:37:39
Message-ID: 10382.1250113059@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Nickolay <nitro(at)zhukcity(dot)ru> writes:
> BUT it seems that rarely this transaction is being delayed to apply and 
> log entry is being inserted in wrong order:
> ID   timestamp
> 1     2009-08-08 00:00:00.111
> 2     2009-08-08 00:00:30.311
> 3     2009-08-08 00:00:00.211
> Yep, that's right - sometimes for 30 seconds or even more.

You haven't provided enough information to let anyone guess at the
problem.  Have you checked to see if one of the processes is blocking
on a lock, or perhaps there's a sudden spike in system load, or what?
Watching pg_stat_activity, pg_locks, and/or "vmstat 1" output during
one of these events might help narrow down what's happening.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2009-08-12 21:57:34
Subject: Re: Why is vacuum_freeze_min_age 100m?
Previous:From: Pierre Frédéric CaillaudDate: 2009-08-12 21:34:19
Subject: Re: transaction delays to apply

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group