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

Re: Autotuning Group Commit

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autotuning Group Commit
Date: 2005-01-24 11:12:24
Message-ID: dpk9v098f54b186jk0aupq957navf5l28t@email.aon.at (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, 21 Jan 2005 23:52:51 +0000, Simon Riggs <simon(at)2ndquadrant(dot)com>
wrote:
>Currently, we have group commit functionality via GUC parameters
>	commit_delay
>and	commit_siblings

And since 7.3 we have ganged WAL writes (c.f. the thread starting at
http://archives.postgresql.org/pgsql-hackers/2002-10/msg00331.php) which
IMHO is a better solution to the same problem.  Maybe the code dealing
with commit_xxx parameters should just be removed.

Are you or is anybody else aware of benchmarks showing that group commit
via commit_xxx is still useful?

Servus
 Manfred

In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2005-01-24 14:57:02
Subject: Re: Locale agnostic unicode text
Previous:From: Pailloncy Jean-GerardDate: 2005-01-24 10:18:24
Subject: Concurrent free-lock

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