Project

General

Profile

# Date Author Comment
13274 04/22/2014 03:57 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: wal_level: set to hot_standby to enable online backup with pg_start_backup()

12620 03/06/2014 10:26 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: log_min_messages: dropped the verbosity back down to the default, to avoid clogging up the logs

12618 03/06/2014 09:51 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: log_min_messages: show what autovacuum is doing

12617 03/06/2014 09:40 PM Aaron Marcuse-Kubitza

fix: schemas/postgresql.conf: disable autovacuum_vacuum_cost_delay to avoid stalling autovacuuming due to a concurrent query, as this can prevent autovacuuming from happening altogether (http://vegpath.org/links/#PostgreSQL:%20Documentation:%209.3:%20Resource%20Consumption:%2018.4.4.%20Cost-based%20Vacuum%20Delay)

11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11797 12/03/2013 02:31 AM Aaron Marcuse-Kubitza

schemas/postgresql.conf: work_mem: documented that this seemingly small # is multiplied by max_connections, i.e. 256 MB * 100 = 26 GB, which approaches total memory (32 GB)

11670 11/15/2013 06:29 AM Aaron Marcuse-Kubitza

schemas/*.conf: upgraded to PostgreSQL 9.3, which is needed for proper exception parsing in the auto-re-create-views functionality

10830 08/30/2013 04:39 PM Aaron Marcuse-Kubitza

fix: schemas/postgresql*.conf: turn on autovacuum logging (log_autovacuum_min_duration = 0) so we can verify if autovacuum is happening

8611 04/23/2013 10:25 AM Aaron Marcuse-Kubitza

schemas/postgresql.conf: shared_buffers: reduced again for Ubuntu VM

8610 04/23/2013 10:22 AM Aaron Marcuse-Kubitza

bugfix: schemas/postgresql.conf: shared_buffers: removed invalid Unicode character U+FEFF

8609 04/23/2013 02:40 AM Aaron Marcuse-Kubitza

schemas/postgresql.conf: shared_buffers: reduced to work in Ubuntu VM

6502 11/30/2012 04:03 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: shared_buffers: Documented that it must be less than ~95% of SHMMAX

6298 11/19/2012 04:59 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Turn on the error log

1721 04/02/2012 09:42 AM Aaron Marcuse-Kubitza

schemas/postgresql*.conf: Increased checkpoint_segments and checkpoint_completion_target so that checkpoints (performance intensive) are written less often and load-balanced better

1657 03/27/2012 07:18 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Decreased shared_buffers again because 4000MB wasn't enough less than 4GB SHMMAX

1656 03/27/2012 07:16 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Expressed shared_buffers in MB, since decimal GB doesn't seem to work anymore on 9.1

1655 03/27/2012 07:14 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Decreased shared_buffers to 3.9GB, slightly less than SHMMAX

1654 03/27/2012 07:11 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Optimized again using same changes as were applied to 8.4 version

1653 03/27/2012 07:10 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Replaced with original 9.1 version

1652 03/27/2012 07:03 PM Aaron Marcuse-Kubitza

schemas/postgresql.conf: Optimized using analogous settings as postgresql.nimoy.conf

1583 03/23/2012 05:53 PM Aaron Marcuse-Kubitza

Added schemas/postgresql.conf