On 7 January 2013 12:39, Amit Kapila <amit.kap...@huawei.com> wrote: > So We can modify to change this in function LogStandbySnapshot as below: > running = GetRunningTransactionData(); > if (running->xcnt > 0) > LogCurrentRunningXacts(running); > > So this check will make sure that if there is no operation happening i.e. no > new running transaction, then no need to log running transaction snapshot > and hence further checkpoint operations will be skipped. > > Let me know if I am missing something?
It's not the same test. The fact that nothing is running at that moment is not the same thing as saying nothing at all has run since last checkpoint. If we skip the WAL record in the way you suggest, we'd be unable to start quickly in some cases. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
