I want to speed up my local database. So I compromise data integrity by not forcing the syncs. Loose a little bit of the ACID, but get some speed

On homebres, I have this file installed in /usr/local/var/db/postgres/postgres.conf

fsync = off				# turns forced synchronization on or off
synchronous_commit = off		# immediate fsync at commit

I want to speed up my local database. So I compromise data integrity by not forcing the syncs. Loose a little bit of the ACID, but get some speed

On homebres, I have this file installed in /usr/local/var/db/postgres/postgres.conf

fsync = off				# turns forced synchronization on or off
synchronous_commit = off		# immediate fsync at commit