pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Ruprecht <chrup999@yahoo.com>
To: Roberto Mello <rmello@cc.usu.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: WAL filling up disk
Date: Tue, 5 Feb 2002 11:23:49 -0600
Message-ID: <p0510120fb885c4f1f45c@[192.168.0.6]> (raw)
In-Reply-To: <20020205165455.GA29166@cc.usu.edu>
References: <20020205165455.GA29166@cc.usu.edu>

Roberto,

in the postgres.conf file is a parameter:
wal_files       = 64 # range 0-64

I'm not sure if you can set this to > 64, I have never tried. Maybe 
that's the guy's problem. Set it to something smaller, like 16 or 32.

Also, he could qualify the update (update xxx set yyy = zzz where 
...) and do the million records in steps of 100'000.

Best regards,
Chris

At 09:54 -0700 02/05/2002, Roberto Mello wrote:
>Hi all,
>
>There was a question on the postgresql-br list the other day that I
>couldn't answer and was curious about it.
>
>This guy has is evaluating PG 7.1(.1?) and has a 1 million records
>table. He then does a "update tablefoo set somefield = 123" and WAL
>eventually causes his 4 Gb disk to fill up and never complete the
>transaction.
>
>According to him, there are over 250 16Mb files under pg_xlog (I
>understand 16 Mb is the default segment file size for WAL).
>
>Can anyone give me more details as to why this happens and the possible
>configurations that should be changed?
>
>Thanks in advance.
>
>-Roberto
>
>--
>+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
>   Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
>        http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer   
>* * * <- Tribbles  . . . <- Tribbles after a haircut
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html


-- 
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com




view thread (8+ messages)  latest in thread

Message-ID: <p0510120fb885c4f1f45c@[192.168.0.6]>
Permalink:  ../p0510120fb885c4f1f45c@%5B192.168.0.6%5D/
Also on:    postgresql.org/message-id/p0510120fb885c4f1f45c@[192.168.0.6]

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: chrup999@yahoo.com, rmello@cc.usu.edu
  Subject: Re: WAL filling up disk
  In-Reply-To: <p0510120fb885c4f1f45c@[192.168.0.6]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox