Re: Excessive (and slow) fsync() within single transaction

From: Vick Khera <vivek(at)khera(dot)org>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Excessive (and slow) fsync() within single transaction
Date: 2009-12-10 03:28:56
Message-ID: 2968dfd60912091928k77ff2daei1f8daa49532a363d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 9, 2009 at 6:24 AM, Stephen Tyler <stephen(at)stephen-tyler(dot)com> wrote:
> Thank you for your suggestions.  I will turn on log_checkpoint next time I
> get the chance to restart.
>

You should be able to set this via a sighup to the server. No restart required.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-12-10 04:56:55 Re: Unix ODBC on SPARC 64 bits
Previous Message J. Greg Davidson 2009-12-10 02:44:37 Seeking expected return type info for SPI function