Re: WAL filling up disk

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