Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com [216.136.173.59]) by postgresql.org (8.11.3/8.11.4) with SMTP id g15HNkl12409 for ; Tue, 5 Feb 2002 12:23:47 -0500 (EST) (envelope-from chrup999@yahoo.com) Received: from chill-025.dfw.tx.bbnow.net (HELO ?192.168.0.6?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 5 Feb 2002 17:23:50 -0000 Mime-Version: 1.0 X-Sender: chrup999@pop.mail.yahoo.com Message-Id: In-Reply-To: <20020205165455.GA29166@cc.usu.edu> References: <20020205165455.GA29166@cc.usu.edu> Date: Tue, 5 Feb 2002 11:23:49 -0600 To: Roberto Mello From: Chris Ruprecht Subject: Re: WAL filling up disk Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/57 X-Sequence-Number: 6488 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