Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org, Greg Smith <greg(at)2ndquadrant(dot)com>
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date: 2010-11-17 01:17:42
Message-ID: 4CE32D36.5040902@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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.

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-11-17 01:17:43 Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Previous Message Andres Freund 2010-11-17 01:12:29 Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?