Skip site navigation (1) Skip section navigation (2)

Re: explanation of some configs

From: justin <justin(at)emproshunts(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: explanation of some configs
Date: 2009-02-10 18:07:23
Message-ID: 4991C25B.7000508@emproshunts.com (view raw or flat)
Thread:
Lists: pgsql-performance
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
checkpoint_segments<br>
Maximum distance between automatic WAL checkpoints, in log file
segments (each segment is normally 16 megabytes).<br>
<br>
Increase these settings if your database has lots of large batch writes
to decrease the frequency of checkpoints (and thus lower disk
activity). Decrease them if you are short on disk space or your
environment has a significant risk of <u><b>unexpected power-outs, as
any un-checkpointed transactions will dropped on restart.</b></u><br>
<br>
Matthew Wakeling wrote:
<blockquote
 cite="mid:alpine(dot)DEB(dot)2(dot)00(dot)0902101208460(dot)3995(at)aragorn(dot)flymine(dot)org"
 type="cite">On Mon, 9 Feb 2009, justin wrote:
  <br>
  <blockquote type="cite">Well then we have conflicting instructions in
places on wiki.postgresql.org which links to this
    <br>
<a class="moz-txt-link-freetext" href="http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html">http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html</a>
    <br>
  </blockquote>
  <br>
Could you be a little more specific as to which sections conflict?
  <br>
  <br>
Matthew
  <br>
  <br>
</blockquote>
</body>
</html>


Attachment: unknown_filename
Description: text/html (1.3 KB)

In response to

Responses

pgsql-performance by date

Next:From: Greg SmithDate: 2009-02-10 19:45:30
Subject: Re: explanation of some configs
Previous:From: Rajesh Kumar MallahDate: 2009-02-10 15:52:39
Subject: Re: query becomes fas on 'SET enable_hashjoin TO off;'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group