Re: CLOG extension - Mailing list pgsql-hackers

From Robert Haas
Subject Re: CLOG extension
Date
Msg-id CA+TgmobS+PzLa+oq3simwakSeJJxtH3Nerh-RdViy0qcgrdHaw@mail.gmail.com
Whole thread Raw
In response to Re: CLOG extension  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, May 3, 2012 at 2:50 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Doing it a background process, though, may make sense.  What I'm a
> little worried about is that - on a busy system - we've only got about
> 2 seconds to complete each CLOG extension, and we must do an fsync in
> order to get there.

Scratch that - we don't routinely need to do an fsync, though we can
end up backed up behind one if wal_buffers are full.  I'm still more
interested in the do-it-a-page-in-advance idea discussed upthread, but
this might be viable as well.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Temporary tables under hot standby
Next
From: Simon Riggs
Date:
Subject: Re: CLOG extension