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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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