pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Roberto Mello <rmello@cc.usu.edu>
To: pgsql-sql@postgresql.org
Subject: WAL filling up disk
Date: Tue, 5 Feb 2002 09:54:55 -0700
Message-ID: <20020205165455.GA29166@cc.usu.edu> (raw)

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



view thread (8+ messages)  latest in thread

Message-ID: <20020205165455.GA29166@cc.usu.edu>
Permalink:  ../20020205165455.GA29166@cc.usu.edu/
Also on:    postgresql.org/message-id/20020205165455.GA29166@cc.usu.edu

 · 

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: rmello@cc.usu.edu
  Subject: Re: WAL filling up disk
  In-Reply-To: <20020205165455.GA29166@cc.usu.edu>

* 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