"Greg Patnude" <gpatnude@xxxxxxxxxxx> writes: > From: Scott Marlowe [mailto:smarlowe@xxxxxxxxxxxxxxxxx] >> So, how often is this running? Once a second, once a minute, once and >> hour? If it's only running once an hour, then something else is wrong. > I've been running it about 2 or 3 times a minute on average... I increased > the " checkpoint_segments" param in postgreSQL.conf from the "factory > default' of 1 to 5... this seems to clear up most of the noise.... The "factory default" has never been 1; AFAIR it's always been 3, and like many of the other defaults that's aimed for small-and-slow machines. If you're not short of disk space, something like 30 is reasonable. (Note this can cost you 32MB per increment, so a setting of 30 means you're willing to invest up to a gigabyte of disk space in WAL. Time was when that was an astonishing amount of disk, but no more...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
