checkpoint_segments 32 megs? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject checkpoint_segments 32 megs?
Date
Msg-id 42D57155.7020508@commandprompt.com
Whole thread Raw
Responses Re: checkpoint_segments 32 megs?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Hello,

Tom made mention earlier this week that upping the checkpoint segments
might be a bad idea because we are committing someone to 32 megs per
segment. I thought it odd at the time but I figured it was an 8.1 thing.

As I review the 8.1dev postgresql.conf the checkpoint_segments option
still states 16 megs per segment is that correct?

Sincerely,

Joshua D. Drake

-- 
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: windows regression failure - prepared xacts
Next
From: Tom Lane
Date:
Subject: Re: commit_delay and commit_siblings