Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date
Msg-id 11497.1289956928@sss.pgh.pa.us
Whole thread Raw
In response to Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Jignesh Shah <jkshah@gmail.com>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>> Well, we're not going to increase the default to gigabytes, but we could
>> very probably increase it by a factor of 10 or so without anyone
>> squawking.  It's been awhile since I heard of anyone trying to run PG in
>> 4MB shmmax.  How much would a change of that size help?

> Last I checked, though, this comes out of the allocation available to
> shared_buffers.  And there definitely are several OSes (several linuxes,
> OSX) still limited to 32MB by default.

Sure, but the current default is a measly 64kB.  We could increase that
10x for a relatively small percentage hit in the size of shared_buffers,
if you suppose that there's 32MB available.  The current default is set
to still work if you've got only a couple of MB in SHMMAX.

What we'd want is for initdb to adjust the setting as part of its
probing to see what SHMMAX is set to.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Next
From: Robert Haas
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?