Postgres Pro
Downloads
Home   >   mailing lists

Re: Excessive (and slow) fsync() within single transaction - Mailing list pgsql-general

From Vick Khera
Subject Re: Excessive (and slow) fsync() within single transaction
Date
Msg-id 2968dfd60912091928k77ff2daei1f8daa49532a363d@mail.gmail.com
Whole thread Raw
In response to Re: Excessive (and slow) fsync() within single transaction  (Stephen Tyler <stephen@stephen-tyler.com>)
List pgsql-general
Tree view 
On Wed, Dec 9, 2009 at 6:24 AM, Stephen Tyler <stephen@stephen-tyler.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.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: pg_dump and ON DELETE CASCADE problem
Next
From: Tom Lane
Date:
Subject: Re: Unix ODBC on SPARC 64 bits