From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: tracking commit timestamps |
Date: | 2013-12-02 07:39:55 |
Message-ID: | CAJKUy5iPw_trv00G8JU14J-oFoRYx0J+nXPvobQ15qqF=akM5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
On Tue, Oct 22, 2013 at 5:16 PM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> Hi,
>
> There has been some interest in keeping track of timestamp of
> transaction commits. This patch implements that.
>
Hi,
Sorry for the delay on the review.
First, because of the recent fixes the patch doesn't apply cleanly
anymore but the changes seems to be easy.
=== performance ===
i expected a regression on performance with the module turned on
because of the new XLOG records and wrote of files in pg_committs but
the performance drop is excessive.
Master 437.835674 tps
Patch, guc off 436.4340982 tps
Patch, guc on 0.370524 tps
This is in a pgbench's db initialized with scale=50 and run with
"pgbench -c 64 -j 16 -n -T 300" 5 times (values above are the average
of runs)
postgresql changes:
shared_buffers = 1GB
full_page_writes = off
checkpoint_segments = 30
checkpoint_timeout = 15min
random_page_cost = 2.0
== functionality ==
I started the server with the module off, then after some work turned
the module on and restarted the server and run a few benchs then
turned it off again and restart the server and get a message like:
"""
LOG: database system was not properly shut down; automatic recovery in progress
LOG: record with zero length at 0/3112AE58
LOG: redo is not required
FATAL: cannot make new WAL entries during recovery
LOG: startup process (PID 24876) exited with exit code 1
LOG: aborting startup due to startup process failure
"""
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2013-12-02 08:57:01 | Re: Proposed feature: Selective Foreign Keys |
Previous Message | Michael Paquier | 2013-12-02 06:40:41 | In-core regression tests for replication, cascading, archiving, PITR, etc. |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-12-03 19:21:00 | Problem logging into the commit fest app |
Previous Message | Sameer Kumar | 2013-11-28 07:03:26 | Re: New Meetup Group for PostgreSQL in Singapore |