Re: transaction delays to apply - Mailing list pgsql-performance

From Pierre Frédéric Caillaud
Subject Re: transaction delays to apply
Date
Msg-id op.uykjjhujcke6l8@soyouz
Whole thread Raw
In response to transaction delays to apply  (Nickolay <nitro@zhukcity.ru>)
List pgsql-performance
> Does anybody know any way to solve this? I did monitor the system
> running at full load (~20 messages per second) - postmaster's processes
> didn't eat more than 10-20% of CPU and memory. Neither did any of my
> application's processes.

now() like current_timestamp is the time of transaction start. If your
client BEGINs, then idles for 30 seconds, then INSERTs, the timestamp in
the insert will be from 30 second ago. Try statement_timestamp() or
clock_timestamp().

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why is vacuum_freeze_min_age 100m?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Why is vacuum_freeze_min_age 100m?