Group commit
From PostgreSQL wiki
(Difference between revisions)
Sternocera (Talk | contribs) |
Sternocera (Talk | contribs) (→Benchmark) |
||
| Line 10: | Line 10: | ||
Benchmarking of this feature has been performed by Greg Smith's pgbench tool (https://github.com/gregs1104/pgbench-tools) . Here are results for the initial benchmark: | Benchmarking of this feature has been performed by Greg Smith's pgbench tool (https://github.com/gregs1104/pgbench-tools) . Here are results for the initial benchmark: | ||
| + | |||
| + | http://wiki.postgresql.org/images/5/50/Group-commit-pgbench-tools.pdf | ||
Revision as of 13:16, 17 January 2012
Group commit
'Group commit is a feature planned for PostgreSQL 9.2 . The feature is being developed by Simon Riggs and Peter Geoghegan. The latest -hackers thread on the feature is: http://archives.postgresql.org/pgsql-hackers/2012-01/msg00804.php .
Description of feature
Broadly speaking, a group commit feature enables PostgreSQL to commit a group of transactions in batch, amortizing the cost of flushing WAL. The proposed implementation this page describes is heavily based on the existing synchronous replication implementation.
Benchmark
Benchmarking of this feature has been performed by Greg Smith's pgbench tool (https://github.com/gregs1104/pgbench-tools) . Here are results for the initial benchmark:
http://wiki.postgresql.org/images/5/50/Group-commit-pgbench-tools.pdf
