Re: Checkpoints are occurring too frequently... - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Checkpoints are occurring too frequently...
Date
Msg-id 42D437E3.8000508@commandprompt.com
Whole thread Raw
In response to Re: Checkpoints are occurring too frequently...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Checkpoints are occurring too frequently...
List pgsql-general
> 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/

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: 7.2 -> 7.4: horrible performance hit!
Next
From: Tom Lane
Date:
Subject: Re: Checkpoints are occurring too frequently...