Re: Checkpoints are occurring too frequently...

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

As this is a fairly common problem, should we consider increasing the
default to 10?

J

>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/