From: | Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Weird WAL problem - 9.0.3 |
Date: | 2011-04-13 13:09:25 |
Message-ID: | 1302700165.8968.126.camel@core2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
Yesterday we had a weird problem with the pg_xlog partition in one of
our servers:
- The amount of WAL files was much higher than (2*checkpoint_segments)+1
(over 360 WAL files)
- The WAL files were not created/recycle time-ordered. Here is an
example:
.....................
16777216 Apr 12 17:49 000000010000000D0000001C
16777216 Apr 12 17:49 000000010000000D0000001D
16777216 Apr 12 17:49 000000010000000D0000001E
16777216 Apr 12 17:52 000000010000000D0000001F
16777216 Apr 12 17:50 000000010000000D00000020
16777216 Apr 12 17:51 000000010000000D00000021
16777216 Apr 12 17:49 000000010000000D00000022
16777216 Apr 12 17:49 000000010000000D00000023
16777216 Apr 12 17:49 000000010000000D00000024
16777216 Apr 12 17:51 000000010000000D00000025
.....................
This is the first time I see this behavior with the result of a full
pg_xlog partition.
This happened when testing an upgrade procedure and moving on the fly
with "pg_dumpall | psql" around 30 databases (ca.140GB) from a 8.3
server to a 9.0 one.
Is this normal? If it is, how can we find out the max.number of WAL
files a 9.0 system can generate in the worst case scenario?
Some relevant information about this system:
------------------------------------------------
PostgreSQL 9.0.3 - ext4 - RHEL5.6 - 2.6.18-238.5.1.el5 - x86_64
checkpoint_segments: 128
wal_buffers: 512kB
wal_level: archive
wal_sync_method: fdatasync
shared_buffers: 10GB
------------------------------------------------
regards,
--
Rafael Martinez Guerrero
Center for Information Technology
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-04-13 13:28:34 | Re: Weird WAL problem - 9.0.3 |
Previous Message | paulo matadr | 2011-04-13 12:02:13 | Postgres 8.3 erro on shared memory windows |