| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | WAL filling up disk |
| Date: | 2002-02-05 16:54:55 |
| Message-ID: | 20020205165455.GA29166@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Isabelle Brette | 2002-02-05 17:05:25 | indexes |
| Previous Message | Roberto Mello | 2002-02-05 15:03:01 | Re: Privil?gios sobre colunas |