Обсуждение: log files
Hello, I'm using PostGreSQL on eComStation (nee OS/2). My system is generating enormous log files in a folder called pg_xlog. They are 16MB each and there are many, many of them. Two questions: 1. Can I delete them and still continue to run? 2. How do I turn off the generation of these files? Thank you all very much. John
Hello John, Those are Write Ahead Log file segments and are part of PostgreSQL's REDO mechanism. On Wed, May 15, 2013 at 5:06 AM, jjurban <jjurban@attglobal.net> wrote: > Hello, > > I'm using PostGreSQL on eComStation (nee OS/2). > > My system is generating enormous log files in a folder called pg_xlog. They > are 16MB each and there are many, many of them. > > Two questions: > > 1. Can I delete them and still continue to run? > > 2. How do I turn off the generation of these files? > > Thank you all very much. > > John > > > > > > -- > Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-novice -- Amit Langote
Hello John, Those are Write Ahead Log (WAL) file segments (16MB each) and are part of PostgreSQL's REDO mechanism. PostgreSQL official documentation on WAL: http://www.postgresql.org/docs/9.2/static/wal.html >1. Can I delete them and still continue to run? You would not be able to recover if you deleted the segments that PostgreSQL would require for recovery. That is, if you delete WAL segments after the last checkpoint, you would not be able to recover consistently. Note that a checkpoint is a point in database operation, all the data changes before which, are guaranteed to be written out to data files (hence consistent). So, all the WAL data after the last checkpoint is essential for consistent should the database crash, since the data changes (that this WAL data represents) have not made to the data files yet. Though, you wouldn't require any of WAL data before a checkpoint (though, you may still keep old WAL files in an archive directory different than pg_xlog to later perform a Point-in-Time-Recovery). >2. How do I turn off the generation of these files? You can not turn off generation of these files. They are an integral part of consistent database operation that ensure integrity and crash safety. Though, you may control the number of such segments under pg_xlog. I would recommend you read PostgreSQL documentation about ways to do this. -- Amit Langote
Thank you for your reply. But the number and size of these WAL files is outrageous. Please see the structure listed below. There are over 5.7 Gigabytes of these files. This cannot be correct. Which of these can I remove? What can I do to avoid generating these monstrous files? Thank you. John ===== structure of WAL files ================================= 188416 0 0 11-16-07 12:29 PGSData/pg_subtrans/0015 16777216 0 0 11-16-07 17:49 PGSData/pg_xlog/00000001000000000000006B 16777216 0 0 10-26-07 10:01 PGSData/pg_xlog/00000001000000000000006C 16777216 0 0 10-30-07 11:09 PGSData/pg_xlog/00000001000000000000006D 16777216 0 0 12-07-07 21:17 PGSData/pg_xlog/00000001000000000000006E 16777216 0 0 12-07-07 21:18 PGSData/pg_xlog/00000001000000000000006F 16777216 0 0 11-12-07 10:50 PGSData/pg_xlog/000000010000000000000070 245760 0 0 01-11-08 13:40 PGSData/pg_subtrans/0016 16777216 0 0 12-21-07 19:10 PGSData/pg_xlog/000000010000000000000071 16777216 0 0 12-28-07 18:18 PGSData/pg_xlog/000000010000000000000072 16777216 0 0 12-03-07 10:46 PGSData/pg_xlog/000000010000000000000073 16777216 0 0 01-04-08 18:55 PGSData/pg_xlog/000000010000000000000074 16777216 0 0 01-11-08 19:32 PGSData/pg_xlog/000000010000000000000075 16777216 0 0 01-18-08 20:45 PGSData/pg_xlog/000000010000000000000076 16777216 0 0 01-18-08 20:48 PGSData/pg_xlog/000000010000000000000077 16777216 0 0 01-25-08 21:14 PGSData/pg_xlog/000000010000000000000078 16777216 0 0 02-01-08 21:19 PGSData/pg_xlog/000000010000000000000079 16777216 0 0 02-01-08 21:19 PGSData/pg_xlog/00000001000000000000007A 16777216 0 0 02-08-08 18:41 PGSData/pg_xlog/00000001000000000000007B 262144 0 0 02-28-08 14:34 PGSData/pg_subtrans/0017 16777216 0 0 02-15-08 22:46 PGSData/pg_xlog/00000001000000000000007C 16777216 0 0 01-18-08 20:45 PGSData/pg_xlog/00000001000000000000007D 16777216 0 0 02-29-08 22:15 PGSData/pg_xlog/00000001000000000000007E 16777216 0 0 02-29-08 22:16 PGSData/pg_xlog/00000001000000000000007F 16777216 0 0 02-01-08 21:19 PGSData/pg_xlog/000000010000000000000080 16777216 0 0 03-07-08 19:02 PGSData/pg_xlog/000000010000000000000081 16777216 0 0 03-14-08 23:09 PGSData/pg_xlog/000000010000000000000082 16777216 0 0 03-20-08 19:29 PGSData/pg_xlog/000000010000000000000083 16777216 0 0 03-20-08 19:29 PGSData/pg_xlog/000000010000000000000084 245760 0 0 04-11-08 11:03 PGSData/pg_subtrans/0018 16777216 0 0 03-28-08 19:41 PGSData/pg_xlog/000000010000000000000085 16777216 0 0 03-05-08 09:58 PGSData/pg_xlog/000000010000000000000086 16777216 0 0 04-04-08 21:59 PGSData/pg_xlog/000000010000000000000087 16777216 0 0 04-04-08 21:59 PGSData/pg_xlog/000000010000000000000088 16777216 0 0 04-18-08 18:07 PGSData/pg_xlog/000000010000000000000089 16777216 0 0 04-18-08 18:08 PGSData/pg_xlog/00000001000000000000008A 16777216 0 0 05-02-08 19:37 PGSData/pg_xlog/00000001000000000000008B 16777216 0 0 05-02-08 19:37 PGSData/pg_xlog/00000001000000000000008C 16777216 0 0 05-09-08 21:08 PGSData/pg_xlog/00000001000000000000008D 16777216 0 0 05-16-08 09:17 PGSData/pg_xlog/00000001000000000000008E 16777216 0 0 05-23-08 22:14 PGSData/pg_xlog/00000001000000000000008F 253952 0 0 06-06-08 21:12 PGSData/pg_subtrans/0019 16777216 0 0 05-30-08 21:36 PGSData/pg_xlog/000000010000000000000090 16777216 0 0 04-28-08 03:11 PGSData/pg_xlog/000000010000000000000091 16777216 0 0 06-06-08 21:12 PGSData/pg_xlog/000000010000000000000092 16777216 0 0 06-13-08 21:22 PGSData/pg_xlog/000000010000000000000093 16777216 0 0 06-13-08 21:22 PGSData/pg_xlog/000000010000000000000094 16777216 0 0 06-20-08 23:25 PGSData/pg_xlog/000000010000000000000095 16777216 0 0 06-27-08 21:44 PGSData/pg_xlog/000000010000000000000096 16777216 0 0 07-03-08 21:39 PGSData/pg_xlog/000000010000000000000097 16777216 0 0 06-02-08 20:37 PGSData/pg_xlog/000000010000000000000098 229376 0 0 07-24-08 10:30 PGSData/pg_subtrans/001A 16777216 0 0 07-11-08 22:57 PGSData/pg_xlog/000000010000000000000099 16777216 0 0 07-11-08 22:57 PGSData/pg_xlog/00000001000000000000009A 16777216 0 0 07-25-08 23:04 PGSData/pg_xlog/00000001000000000000009B 16777216 0 0 06-25-08 10:39 PGSData/pg_xlog/00000001000000000000009C 16777216 0 0 06-30-08 18:28 PGSData/pg_xlog/00000001000000000000009D 16777216 0 0 07-07-08 18:51 PGSData/pg_xlog/00000001000000000000009E 16777216 0 0 08-08-08 16:52 PGSData/pg_xlog/00000001000000000000009F 16777216 0 0 08-15-08 19:45 PGSData/pg_xlog/0000000100000000000000A0 16777216 0 0 08-29-08 20:37 PGSData/pg_xlog/0000000100000000000000A1 262144 0 0 09-17-08 10:14 PGSData/pg_subtrans/001B 16777216 0 0 08-29-08 20:38 PGSData/pg_xlog/0000000100000000000000A2 16777216 0 0 08-01-08 15:11 PGSData/pg_xlog/0000000100000000000000A3 16777216 0 0 09-05-08 23:04 PGSData/pg_xlog/0000000100000000000000A4 16777216 0 0 08-08-08 16:50 PGSData/pg_xlog/0000000100000000000000A5 16777216 0 0 09-19-08 22:26 PGSData/pg_xlog/0000000100000000000000A6 16777216 0 0 09-26-08 22:21 PGSData/pg_xlog/0000000100000000000000A7 16777216 0 0 08-29-08 20:37 PGSData/pg_xlog/0000000100000000000000A8 16777216 0 0 10-03-08 23:20 PGSData/pg_xlog/0000000100000000000000A9 16777216 0 0 10-10-08 21:05 PGSData/pg_xlog/0000000100000000000000AA 16777216 0 0 10-17-08 23:34 PGSData/pg_xlog/0000000100000000000000AB 16777216 0 0 10-17-08 23:34 PGSData/pg_xlog/0000000100000000000000AC 262144 0 0 11-06-08 13:38 PGSData/pg_subtrans/001C 16777216 0 0 09-23-08 14:38 PGSData/pg_xlog/0000000100000000000000AD 16777216 0 0 11-07-08 18:47 PGSData/pg_xlog/0000000100000000000000AE 16777216 0 0 11-07-08 18:48 PGSData/pg_xlog/0000000100000000000000AF 16777216 0 0 11-14-08 21:46 PGSData/pg_xlog/0000000100000000000000B0 16777216 0 0 10-10-08 21:05 PGSData/pg_xlog/0000000100000000000000B1 16777216 0 0 12-03-08 14:39 PGSData/pg_xlog/0000000100000000000000B2 16777216 0 0 12-05-08 22:11 PGSData/pg_xlog/0000000100000000000000B3 16777216 0 0 12-12-08 17:11 PGSData/pg_xlog/0000000100000000000000B4 172032 0 0 12-12-08 13:30 PGSData/pg_subtrans/001D 16777216 0 0 11-07-08 18:47 PGSData/pg_xlog/0000000100000000000000B5 16777216 0 0 11-10-08 12:25 PGSData/pg_xlog/0000000100000000000000B6 16777216 0 0 01-09-09 23:38 PGSData/pg_xlog/0000000100000000000000B7 16777216 0 0 01-09-09 23:39 PGSData/pg_xlog/0000000100000000000000B8 16777216 0 0 01-16-09 22:47 PGSData/pg_xlog/0000000100000000000000B9 16777216 0 0 01-23-09 21:55 PGSData/pg_xlog/0000000100000000000000BA 245760 0 0 02-19-09 23:21 PGSData/pg_subtrans/001E 16777216 0 0 01-30-09 21:26 PGSData/pg_xlog/0000000100000000000000BB 16777216 0 0 01-30-09 21:28 PGSData/pg_xlog/0000000100000000000000BC 16777216 0 0 02-06-09 21:06 PGSData/pg_xlog/0000000100000000000000BD 16777216 0 0 02-13-09 21:25 PGSData/pg_xlog/0000000100000000000000BE 16777216 0 0 02-13-09 21:26 PGSData/pg_xlog/0000000100000000000000BF 16777216 0 0 02-20-09 23:07 PGSData/pg_xlog/0000000100000000000000C0 16777216 0 0 02-27-09 21:14 PGSData/pg_xlog/0000000100000000000000C1 16777216 0 0 03-06-09 22:11 PGSData/pg_xlog/0000000100000000000000C2 16777216 0 0 03-13-09 23:03 PGSData/pg_xlog/0000000100000000000000C3 16777216 0 0 03-20-09 22:33 PGSData/pg_xlog/0000000100000000000000C4 16777216 0 0 03-27-09 22:14 PGSData/pg_xlog/0000000100000000000000C5 16777216 0 0 04-03-09 23:13 PGSData/pg_xlog/0000000100000000000000C6 180224 0 0 04-01-09 15:36 PGSData/pg_subtrans/001F 16777216 0 0 02-24-09 12:59 PGSData/pg_xlog/0000000100000000000000C7 16777216 0 0 03-02-09 09:54 PGSData/pg_xlog/0000000100000000000000C8 16777216 0 0 04-24-09 21:26 PGSData/pg_xlog/0000000100000000000000C9 16777216 0 0 04-24-09 21:26 PGSData/pg_xlog/0000000100000000000000CA 16777216 0 0 05-01-09 21:55 PGSData/pg_xlog/0000000100000000000000CB 16777216 0 0 05-15-09 22:55 PGSData/pg_xlog/0000000100000000000000CC 262144 0 0 08-29-11 00:11 PGSData/pg_clog/0002 221184 0 0 06-04-09 22:23 PGSData/pg_subtrans/0020 16777216 0 0 05-22-09 22:06 PGSData/pg_xlog/0000000100000000000000CD 16777216 0 0 05-29-09 22:03 PGSData/pg_xlog/0000000100000000000000CE 16777216 0 0 04-20-09 10:16 PGSData/pg_xlog/0000000100000000000000CF 16777216 0 0 06-05-09 19:19 PGSData/pg_xlog/0000000100000000000000D0 16777216 0 0 06-19-09 21:44 PGSData/pg_xlog/0000000100000000000000D1 16777216 0 0 06-26-09 22:42 PGSData/pg_xlog/0000000100000000000000D2 16777216 0 0 06-26-09 22:43 PGSData/pg_xlog/0000000100000000000000D3 16777216 0 0 07-02-09 22:53 PGSData/pg_xlog/0000000100000000000000D4 16777216 0 0 07-10-09 22:40 PGSData/pg_xlog/0000000100000000000000D5 16777216 0 0 07-17-09 20:51 PGSData/pg_xlog/0000000100000000000000D6 196608 0 0 07-30-09 09:34 PGSData/pg_subtrans/0021 16777216 0 0 07-31-09 23:40 PGSData/pg_xlog/0000000100000000000000D7 16777216 0 0 06-19-09 21:44 PGSData/pg_xlog/0000000100000000000000D8 16777216 0 0 08-14-09 22:09 PGSData/pg_xlog/0000000100000000000000D9 16777216 0 0 08-21-09 23:13 PGSData/pg_xlog/0000000100000000000000DA 16777216 0 0 08-28-09 22:39 PGSData/pg_xlog/0000000100000000000000DB 16777216 0 0 08-28-09 22:39 PGSData/pg_xlog/0000000100000000000000DC 16777216 0 0 09-13-09 20:38 PGSData/pg_xlog/0000000100000000000000DD 253952 0 0 10-09-09 09:08 PGSData/pg_subtrans/0022 16777216 0 0 09-19-09 23:37 PGSData/pg_xlog/0000000100000000000000DE 16777216 0 0 09-25-09 22:08 PGSData/pg_xlog/0000000100000000000000DF 16777216 0 0 08-14-09 22:09 PGSData/pg_xlog/0000000100000000000000E0 16777216 0 0 08-24-09 06:53 PGSData/pg_xlog/0000000100000000000000E1 16777216 0 0 10-10-09 23:49 PGSData/pg_xlog/0000000100000000000000E2 16777216 0 0 10-23-09 20:29 PGSData/pg_xlog/0000000100000000000000E3 16777216 0 0 10-30-09 21:55 PGSData/pg_xlog/0000000100000000000000E4 16777216 0 0 11-06-09 20:36 PGSData/pg_xlog/0000000100000000000000E5 16777216 0 0 11-13-09 23:54 PGSData/pg_xlog/0000000100000000000000E6 16777216 0 0 10-05-09 20:34 PGSData/pg_xlog/0000000100000000000000E7 16777216 0 0 11-25-09 22:18 PGSData/pg_xlog/0000000100000000000000E8 262144 0 0 12-04-09 10:56 PGSData/pg_subtrans/0023 16777216 0 0 10-19-09 11:49 PGSData/pg_xlog/0000000100000000000000E9 16777216 0 0 12-04-09 23:22 PGSData/pg_xlog/0000000100000000000000EA 16777216 0 0 12-11-09 21:30 PGSData/pg_xlog/0000000100000000000000EB 16777216 0 0 12-23-09 17:26 PGSData/pg_xlog/0000000100000000000000EC 16777216 0 0 12-31-09 16:47 PGSData/pg_xlog/0000000100000000000000ED 16777216 0 0 12-31-09 16:48 PGSData/pg_xlog/0000000100000000000000EE 16777216 0 0 01-08-10 23:47 PGSData/pg_xlog/0000000100000000000000EF 16777216 0 0 01-15-10 21:43 PGSData/pg_xlog/0000000100000000000000F0 262144 0 0 01-22-10 07:52 PGSData/pg_subtrans/0024 16777216 0 0 01-22-10 21:17 PGSData/pg_xlog/0000000100000000000000F1 16777216 0 0 01-29-10 22:07 PGSData/pg_xlog/0000000100000000000000F2 16777216 0 0 12-23-09 17:26 PGSData/pg_xlog/0000000100000000000000F3 16777216 0 0 02-12-10 17:29 PGSData/pg_xlog/0000000100000000000000F4 16777216 0 0 02-19-10 20:33 PGSData/pg_xlog/0000000100000000000000F5 16777216 0 0 02-26-10 21:05 PGSData/pg_xlog/0000000100000000000000F6 16777216 0 0 03-05-10 16:27 PGSData/pg_xlog/0000000100000000000000F7 253952 0 0 03-15-10 16:48 PGSData/pg_subtrans/0025 16777216 0 0 03-12-10 21:11 PGSData/pg_xlog/0000000100000000000000F8 16777216 0 0 03-19-10 19:09 PGSData/pg_xlog/0000000100000000000000F9 16777216 0 0 03-26-10 21:55 PGSData/pg_xlog/0000000100000000000000FA 16777216 0 0 04-01-10 18:22 PGSData/pg_xlog/0000000100000000000000FB 16777216 0 0 04-09-10 21:45 PGSData/pg_xlog/0000000100000000000000FC 16777216 0 0 03-03-10 10:11 PGSData/pg_xlog/0000000100000000000000FD 16777216 0 0 04-30-10 21:25 PGSData/pg_xlog/0000000100000000000000FE 16777216 0 0 05-07-10 18:15 PGSData/pg_xlog/000000010000000100000000 237568 0 0 05-04-10 19:04 PGSData/pg_subtrans/0026 16777216 0 0 05-07-10 18:15 PGSData/pg_xlog/000000010000000100000001 16777216 0 0 05-14-10 23:13 PGSData/pg_xlog/000000010000000100000002 16777216 0 0 04-07-10 19:00 PGSData/pg_xlog/000000010000000100000003 16777216 0 0 06-04-10 21:06 PGSData/pg_xlog/000000010000000100000004 16777216 0 0 06-04-10 21:07 PGSData/pg_xlog/000000010000000100000005 16777216 0 0 04-30-10 21:25 PGSData/pg_xlog/000000010000000100000006 237568 0 0 06-24-10 22:31 PGSData/pg_subtrans/0027 16777216 0 0 06-18-10 20:18 PGSData/pg_xlog/000000010000000100000007 16777216 0 0 06-25-10 22:02 PGSData/pg_xlog/000000010000000100000008 16777216 0 0 07-09-10 23:28 PGSData/pg_xlog/000000010000000100000009 16777216 0 0 07-09-10 23:29 PGSData/pg_xlog/00000001000000010000000A 16777216 0 0 07-16-10 20:33 PGSData/pg_xlog/00000001000000010000000B 16777216 0 0 07-23-10 19:11 PGSData/pg_xlog/00000001000000010000000C 16777216 0 0 07-30-10 22:03 PGSData/pg_xlog/00000001000000010000000D 16777216 0 0 08-13-10 22:31 PGSData/pg_xlog/00000001000000010000000E 196608 0 0 08-12-10 17:54 PGSData/pg_subtrans/0028 16777216 0 0 08-13-10 22:32 PGSData/pg_xlog/00000001000000010000000F 16777216 0 0 07-09-10 23:28 PGSData/pg_xlog/000000010000000100000010 16777216 0 0 09-04-10 22:01 PGSData/pg_xlog/000000010000000100000011 16777216 0 0 09-10-10 20:35 PGSData/pg_xlog/000000010000000100000012 16777216 0 0 07-26-10 18:48 PGSData/pg_xlog/000000010000000100000013 16777216 0 0 09-24-10 23:43 PGSData/pg_xlog/000000010000000100000014 262144 0 0 10-16-10 11:13 PGSData/pg_subtrans/0029 16777216 0 0 08-13-10 22:31 PGSData/pg_xlog/000000010000000100000015 16777216 0 0 10-08-10 20:50 PGSData/pg_xlog/000000010000000100000016 16777216 0 0 10-08-10 20:51 PGSData/pg_xlog/000000010000000100000017 16777216 0 0 10-16-10 20:27 PGSData/pg_xlog/000000010000000100000018 16777216 0 0 09-13-10 13:00 PGSData/pg_xlog/000000010000000100000019 16777216 0 0 10-29-10 21:15 PGSData/pg_xlog/00000001000000010000001A 16777216 0 0 11-05-10 22:57 PGSData/pg_xlog/00000001000000010000001B 16777216 0 0 11-12-10 21:12 PGSData/pg_xlog/00000001000000010000001C 16777216 0 0 11-24-10 22:27 PGSData/pg_xlog/00000001000000010000001D 16777216 0 0 11-24-10 22:27 PGSData/pg_xlog/00000001000000010000001E 262144 0 0 12-03-10 16:38 PGSData/pg_subtrans/002A 16777216 0 0 12-03-10 16:38 PGSData/pg_xlog/00000001000000010000001F 16777216 0 0 12-10-10 16:54 PGSData/pg_xlog/000000010000000100000020 16777216 0 0 12-17-10 20:37 PGSData/pg_xlog/000000010000000100000021 16777216 0 0 11-11-10 22:12 PGSData/pg_xlog/000000010000000100000022 16777216 0 0 01-07-11 20:10 PGSData/pg_xlog/000000010000000100000023 16777216 0 0 01-07-11 20:11 PGSData/pg_xlog/000000010000000100000024 16777216 0 0 01-14-11 23:26 PGSData/pg_xlog/000000010000000100000025 237568 0 0 01-21-11 10:51 PGSData/pg_subtrans/002B 16777216 0 0 01-21-11 21:32 PGSData/pg_xlog/000000010000000100000026 16777216 0 0 01-28-11 22:35 PGSData/pg_xlog/000000010000000100000027 16777216 0 0 02-05-11 14:52 PGSData/pg_xlog/000000010000000100000028 16777216 0 0 02-11-11 20:34 PGSData/pg_xlog/000000010000000100000029 16777216 0 0 02-18-11 23:04 PGSData/pg_xlog/00000001000000010000002A 16777216 0 0 01-14-11 14:01 PGSData/pg_xlog/00000001000000010000002B 16777216 0 0 03-04-11 17:43 PGSData/pg_xlog/00000001000000010000002C 237568 0 0 03-09-11 11:35 PGSData/pg_subtrans/002C 16777216 0 0 03-11-11 21:46 PGSData/pg_xlog/00000001000000010000002D 16777216 0 0 03-18-11 21:35 PGSData/pg_xlog/00000001000000010000002E 16777216 0 0 03-18-11 21:44 PGSData/pg_xlog/00000001000000010000002F 16777216 0 0 03-25-11 17:25 PGSData/pg_xlog/000000010000000100000030 16777216 0 0 04-01-11 19:49 PGSData/pg_xlog/000000010000000100000031 16777216 0 0 04-08-11 17:59 PGSData/pg_xlog/000000010000000100000032 16777216 0 0 04-15-11 18:01 PGSData/pg_xlog/000000010000000100000033 245760 0 0 04-28-11 14:31 PGSData/pg_subtrans/002D 16777216 0 0 04-21-11 18:46 PGSData/pg_xlog/000000010000000100000034 16777216 0 0 04-21-11 18:47 PGSData/pg_xlog/000000010000000100000035 16777216 0 0 05-06-11 16:59 PGSData/pg_xlog/000000010000000100000036 16777216 0 0 05-13-11 23:55 PGSData/pg_xlog/000000010000000100000037 16777216 0 0 05-21-11 15:27 PGSData/pg_xlog/000000010000000100000038 16777216 0 0 05-27-11 21:42 PGSData/pg_xlog/000000010000000100000039 16777216 0 0 06-03-11 20:09 PGSData/pg_xlog/00000001000000010000003A 16777216 0 0 06-10-11 17:06 PGSData/pg_xlog/00000001000000010000003B 16777216 0 0 06-17-11 19:06 PGSData/pg_xlog/00000001000000010000003C 262144 0 0 06-30-11 14:19 PGSData/pg_subtrans/002E 16777216 0 0 06-24-11 16:53 PGSData/pg_xlog/00000001000000010000003D 16777216 0 0 07-01-11 21:33 PGSData/pg_xlog/00000001000000010000003E 16777216 0 0 07-08-11 17:20 PGSData/pg_xlog/00000001000000010000003F 16777216 0 0 07-15-11 16:34 PGSData/pg_xlog/000000010000000100000040 16777216 0 0 07-22-11 20:04 PGSData/pg_xlog/000000010000000100000041 16777216 0 0 07-29-11 16:03 PGSData/pg_xlog/000000010000000100000042 16777216 0 0 08-05-11 18:30 PGSData/pg_xlog/000000010000000100000043 16777216 0 0 08-12-11 17:13 PGSData/pg_xlog/000000010000000100000044 262144 0 0 08-26-11 11:20 PGSData/pg_subtrans/002F 16777216 0 0 08-19-11 20:38 PGSData/pg_xlog/000000010000000100000045 16777216 0 0 08-26-11 20:20 PGSData/pg_xlog/000000010000000100000046 16777216 0 0 09-02-11 18:03 PGSData/pg_xlog/000000010000000100000047 16777216 0 0 09-09-11 21:04 PGSData/pg_xlog/000000010000000100000048 16777216 0 0 09-16-11 17:33 PGSData/pg_xlog/000000010000000100000049 16777216 0 0 09-23-11 16:52 PGSData/pg_xlog/00000001000000010000004A 16777216 0 0 09-23-11 16:53 PGSData/pg_xlog/00000001000000010000004B 16777216 0 0 09-30-11 21:20 PGSData/pg_xlog/00000001000000010000004C 245760 0 0 05-10-13 13:51 PGSData/pg_clog/0003 229376 0 0 10-05-11 10:51 PGSData/pg_subtrans/0030 16777216 0 0 10-07-11 20:52 PGSData/pg_xlog/00000001000000010000004D 16777216 0 0 10-14-11 20:15 PGSData/pg_xlog/00000001000000010000004E 16777216 0 0 10-14-11 20:16 PGSData/pg_xlog/00000001000000010000004F 16777216 0 0 10-28-11 18:45 PGSData/pg_xlog/000000010000000100000050 16777216 0 0 10-28-11 18:47 PGSData/pg_xlog/000000010000000100000051 16777216 0 0 11-04-11 21:04 PGSData/pg_xlog/000000010000000100000052 16777216 0 0 09-30-11 21:20 PGSData/pg_xlog/000000010000000100000053 245760 0 0 11-23-11 18:32 PGSData/pg_subtrans/0031 16777216 0 0 10-10-11 04:34 PGSData/pg_xlog/000000010000000100000054 16777216 0 0 11-24-11 01:52 PGSData/pg_xlog/000000010000000100000055 16777216 0 0 11-24-11 01:53 PGSData/pg_xlog/000000010000000100000056 16777216 0 0 12-09-11 20:16 PGSData/pg_xlog/000000010000000100000057 16777216 0 0 12-09-11 20:18 PGSData/pg_xlog/000000010000000100000058 16777216 0 0 12-17-11 17:18 PGSData/pg_xlog/000000010000000100000059 16777216 0 0 12-22-11 17:28 PGSData/pg_xlog/00000001000000010000005A 16777216 0 0 12-30-11 22:00 PGSData/pg_xlog/00000001000000010000005B 237568 0 0 01-12-12 13:31 PGSData/pg_subtrans/0032 16777216 0 0 11-24-11 01:52 PGSData/pg_xlog/00000001000000010000005C 16777216 0 0 01-14-12 17:49 PGSData/pg_xlog/00000001000000010000005D 16777216 0 0 01-21-12 19:12 PGSData/pg_xlog/00000001000000010000005E 16777216 0 0 12-15-11 10:06 PGSData/pg_xlog/00000001000000010000005F 16777216 0 0 01-28-12 15:39 PGSData/pg_xlog/000000010000000100000060 16777216 0 0 12-23-11 17:35 PGSData/pg_xlog/000000010000000100000061 16777216 0 0 02-10-12 17:03 PGSData/pg_xlog/000000010000000100000062 16777216 0 0 02-10-12 17:05 PGSData/pg_xlog/000000010000000100000063 245760 0 0 02-24-12 13:56 PGSData/pg_subtrans/0033 16777216 0 0 01-16-12 19:06 PGSData/pg_xlog/000000010000000100000064 16777216 0 0 02-24-12 16:00 PGSData/pg_xlog/000000010000000100000065 16777216 0 0 01-27-12 02:02 PGSData/pg_xlog/000000010000000100000066 16777216 0 0 01-30-12 01:16 PGSData/pg_xlog/000000010000000100000067 16777216 0 0 03-09-12 21:21 PGSData/pg_xlog/000000010000000100000068 16777216 0 0 02-10-12 17:03 PGSData/pg_xlog/000000010000000100000069 16777216 0 0 03-25-12 00:43 PGSData/pg_xlog/00000001000000010000006A 16777216 0 0 03-25-12 00:45 PGSData/pg_xlog/00000001000000010000006B 237568 0 0 04-02-12 06:30 PGSData/pg_subtrans/0034 16777216 0 0 04-05-12 21:12 PGSData/pg_xlog/00000001000000010000006C 16777216 0 0 04-05-12 21:13 PGSData/pg_xlog/00000001000000010000006D 16777216 0 0 03-09-12 10:36 PGSData/pg_xlog/00000001000000010000006E 16777216 0 0 04-20-12 20:18 PGSData/pg_xlog/00000001000000010000006F 16777216 0 0 04-20-12 20:19 PGSData/pg_xlog/000000010000000100000070 16777216 0 0 03-25-12 00:43 PGSData/pg_xlog/000000010000000100000071 16777216 0 0 03-29-12 12:03 PGSData/pg_xlog/000000010000000100000072 221184 0 0 05-11-12 13:32 PGSData/pg_subtrans/0035 16777216 0 0 05-11-12 21:28 PGSData/pg_xlog/000000010000000100000073 16777216 0 0 04-12-12 08:41 PGSData/pg_xlog/000000010000000100000074 16777216 0 0 04-17-12 14:29 PGSData/pg_xlog/000000010000000100000075 16777216 0 0 04-20-12 20:18 PGSData/pg_xlog/000000010000000100000076 16777216 0 0 06-03-12 00:33 PGSData/pg_xlog/000000010000000100000077 16777216 0 0 05-05-12 13:45 PGSData/pg_xlog/000000010000000100000078 16777216 0 0 05-11-12 10:35 PGSData/pg_xlog/000000010000000100000079 253952 0 0 06-22-12 12:43 PGSData/pg_subtrans/0036 16777216 0 0 05-12-12 08:57 PGSData/pg_xlog/00000001000000010000007A 16777216 0 0 06-15-12 21:06 PGSData/pg_xlog/00000001000000010000007B 16777216 0 0 06-15-12 21:07 PGSData/pg_xlog/00000001000000010000007C 16777216 0 0 06-22-12 17:39 PGSData/pg_xlog/00000001000000010000007D 16777216 0 0 06-04-12 00:59 PGSData/pg_xlog/00000001000000010000007E 16777216 0 0 07-06-12 18:50 PGSData/pg_xlog/00000001000000010000007F 16777216 0 0 07-06-12 18:52 PGSData/pg_xlog/000000010000000100000080 16777216 0 0 07-13-12 23:50 PGSData/pg_xlog/000000010000000100000081 16777216 0 0 07-21-12 19:15 PGSData/pg_xlog/000000010000000100000082 16777216 0 0 07-27-12 22:54 PGSData/pg_xlog/000000010000000100000083 196608 0 0 07-26-12 08:01 PGSData/pg_subtrans/0037 16777216 0 0 07-27-12 22:56 PGSData/pg_xlog/000000010000000100000084 16777216 0 0 06-29-12 21:07 PGSData/pg_xlog/000000010000000100000085 16777216 0 0 08-10-12 20:13 PGSData/pg_xlog/000000010000000100000086 16777216 0 0 08-10-12 20:15 PGSData/pg_xlog/000000010000000100000087 16777216 0 0 08-17-12 20:23 PGSData/pg_xlog/000000010000000100000088 16777216 0 0 08-24-12 16:06 PGSData/pg_xlog/000000010000000100000089 253952 0 0 09-13-12 14:41 PGSData/pg_subtrans/0038 16777216 0 0 08-24-12 16:07 PGSData/pg_xlog/00000001000000010000008A 16777216 0 0 08-31-12 20:19 PGSData/pg_xlog/00000001000000010000008B 16777216 0 0 09-07-12 22:42 PGSData/pg_xlog/00000001000000010000008C 16777216 0 0 09-14-12 21:21 PGSData/pg_xlog/00000001000000010000008D 16777216 0 0 09-21-12 18:23 PGSData/pg_xlog/00000001000000010000008E 16777216 0 0 09-28-12 15:37 PGSData/pg_xlog/00000001000000010000008F 16777216 0 0 09-28-12 15:38 PGSData/pg_xlog/000000010000000100000090 16777216 0 0 10-05-12 18:50 PGSData/pg_xlog/000000010000000100000091 16777216 0 0 10-12-12 17:41 PGSData/pg_xlog/000000010000000100000092 16777216 0 0 09-10-12 11:08 PGSData/pg_xlog/000000010000000100000093 253952 0 0 10-25-12 13:29 PGSData/pg_subtrans/0039 16777216 0 0 10-24-12 16:35 PGSData/pg_xlog/000000010000000100000094 16777216 0 0 10-31-12 17:17 PGSData/pg_xlog/000000010000000100000095 16777216 0 0 11-02-12 23:03 PGSData/pg_xlog/000000010000000100000096 16777216 0 0 11-09-12 17:08 PGSData/pg_xlog/000000010000000100000097 16777216 0 0 11-09-12 17:10 PGSData/pg_xlog/000000010000000100000098 16777216 0 0 11-16-12 17:47 PGSData/pg_xlog/000000010000000100000099 16777216 0 0 10-22-12 16:58 PGSData/pg_xlog/00000001000000010000009A 16777216 0 0 11-26-12 20:24 PGSData/pg_xlog/00000001000000010000009B 253952 0 0 12-07-12 21:45 PGSData/pg_subtrans/003A 16777216 0 0 12-07-12 21:44 PGSData/pg_xlog/00000001000000010000009C 16777216 0 0 12-07-12 21:45 PGSData/pg_xlog/00000001000000010000009D 16777216 0 0 12-14-12 20:45 PGSData/pg_xlog/00000001000000010000009E 16777216 0 0 12-21-12 23:14 PGSData/pg_xlog/00000001000000010000009F 16777216 0 0 12-29-12 20:43 PGSData/pg_xlog/0000000100000001000000A0 16777216 0 0 11-26-12 20:23 PGSData/pg_xlog/0000000100000001000000A1 16777216 0 0 01-12-13 00:17 PGSData/pg_xlog/0000000100000001000000A2 237568 0 0 01-18-13 10:46 PGSData/pg_subtrans/003B 16777216 0 0 01-19-13 00:28 PGSData/pg_xlog/0000000100000001000000A3 16777216 0 0 12-14-12 11:03 PGSData/pg_xlog/0000000100000001000000A4 16777216 0 0 01-25-13 17:45 PGSData/pg_xlog/0000000100000001000000A5 16777216 0 0 02-01-13 19:12 PGSData/pg_xlog/0000000100000001000000A6 16777216 0 0 02-01-13 19:14 PGSData/pg_xlog/0000000100000001000000A7 16777216 0 0 02-08-13 16:28 PGSData/pg_xlog/0000000100000001000000A8 16777216 0 0 02-15-13 17:10 PGSData/pg_xlog/0000000100000001000000A9 253952 0 0 03-01-13 10:37 PGSData/pg_subtrans/003C 16777216 0 0 02-22-13 17:16 PGSData/pg_xlog/0000000100000001000000AA 16777216 0 0 02-22-13 17:18 PGSData/pg_xlog/0000000100000001000000AB 16777216 0 0 03-01-13 16:43 PGSData/pg_xlog/0000000100000001000000AC 16777216 0 0 03-08-13 16:08 PGSData/pg_xlog/0000000100000001000000AD 16777216 0 0 03-15-13 18:18 PGSData/pg_xlog/0000000100000001000000AE 16777216 0 0 02-12-13 01:37 PGSData/pg_xlog/0000000100000001000000AF 16777216 0 0 03-22-13 19:14 PGSData/pg_xlog/0000000100000001000000B0 16777216 0 0 03-28-13 21:13 PGSData/pg_xlog/0000000100000001000000B1 16777216 0 0 04-05-13 19:38 PGSData/pg_xlog/0000000100000001000000B2 253952 0 0 04-12-13 17:50 PGSData/pg_subtrans/003D 16777216 0 0 04-05-13 19:45 PGSData/pg_xlog/0000000100000001000000B3 16777216 0 0 04-12-13 17:50 PGSData/pg_xlog/0000000100000001000000B4 16777216 0 0 04-20-13 00:10 PGSData/pg_xlog/0000000100000001000000B5 16777216 0 0 04-25-13 20:34 PGSData/pg_xlog/0000000100000001000000B6 16777216 0 0 05-03-13 20:51 PGSData/pg_xlog/0000000100000001000000B7 16777216 0 0 05-03-13 20:52 PGSData/pg_xlog/0000000100000001000000B8 16777216 0 0 05-10-13 11:35 PGSData/pg_xlog/0000000100000001000000B9 16777216 0 0 05-10-13 13:51 PGSData/pg_xlog/0000000100000001000000BA 163840 0 0 05-10-13 13:51 PGSData/pg_subtrans/003E 16777216 0 0 04-16-13 10:47 PGSData/pg_xlog/0000000100000001000000BB 16777216 0 0 04-23-13 08:54 PGSData/pg_xlog/0000000100000001000000BC 16777216 0 0 04-29-13 06:23 PGSData/pg_xlog/0000000100000001000000BD 16777216 0 0 05-03-13 20:51 PGSData/pg_xlog/0000000100000001000000BE 16777216 0 0 05-06-13 14:12 PGSData/pg_xlog/0000000100000001000000BF 16777216 0 0 05-10-13 11:35 PGSData/pg_xlog/0000000100000001000000C0 -------- ----- ----- ------- Total = 5.7315E+09 bytes Amit Langote wrote: > Hello John, > > Those are Write Ahead Log (WAL) file segments (16MB each) and are part > of PostgreSQL's REDO mechanism. > PostgreSQL official documentation on WAL: > > http://www.postgresql.org/docs/9.2/static/wal.html > > >> 1. Can I delete them and still continue to run? >> > > You would not be able to recover if you deleted the segments that > PostgreSQL would require for recovery. That is, if you delete WAL > segments after the last checkpoint, you would not be able to recover > consistently. Note that a checkpoint is a point in database operation, > all the data changes before which, are guaranteed to be written out to > data files (hence consistent). So, all the WAL data after the last > checkpoint is essential for consistent should the database crash, > since the data changes (that this WAL data represents) have not made > to the data files yet. Though, you wouldn't require any of WAL data > before a checkpoint (though, you may still keep old WAL files in an > archive directory different than pg_xlog to later perform a > Point-in-Time-Recovery). > > >> 2. How do I turn off the generation of these files? >> > > You can not turn off generation of these files. They are an integral > part of consistent database operation that ensure integrity and crash > safety. Though, you may control the number of such segments under > pg_xlog. I would recommend you read PostgreSQL documentation about > ways to do this. > > > -- > Amit Langote > > >
Please see comment at the bottom. On 16/05/13 07:01, jjurban wrote: > Thank you for your reply. > > But the number and size of these WAL files is outrageous. Please see > the structure listed below. > > There are over 5.7 Gigabytes of these files. This cannot be correct. > > Which of these can I remove? > > What can I do to avoid generating these monstrous files? > > Thank you. > > John > > ===== structure of WAL files ================================= > 188416 0 0 11-16-07 12:29 PGSData/pg_subtrans/0015 > 16777216 0 0 11-16-07 17:49 > PGSData/pg_xlog/00000001000000000000006B > 16777216 0 0 10-26-07 10:01 > PGSData/pg_xlog/00000001000000000000006C > 16777216 0 0 10-30-07 11:09 > PGSData/pg_xlog/00000001000000000000006D > 16777216 0 0 12-07-07 21:17 > PGSData/pg_xlog/00000001000000000000006E > 16777216 0 0 12-07-07 21:18 > PGSData/pg_xlog/00000001000000000000006F > 16777216 0 0 11-12-07 10:50 > PGSData/pg_xlog/000000010000000000000070 > 245760 0 0 01-11-08 13:40 PGSData/pg_subtrans/0016 > 16777216 0 0 12-21-07 19:10 > PGSData/pg_xlog/000000010000000000000071 > 16777216 0 0 12-28-07 18:18 > PGSData/pg_xlog/000000010000000000000072 > 16777216 0 0 12-03-07 10:46 > PGSData/pg_xlog/000000010000000000000073 > 16777216 0 0 01-04-08 18:55 > PGSData/pg_xlog/000000010000000000000074 > 16777216 0 0 01-11-08 19:32 > PGSData/pg_xlog/000000010000000000000075 > 16777216 0 0 01-18-08 20:45 > PGSData/pg_xlog/000000010000000000000076 > 16777216 0 0 01-18-08 20:48 > PGSData/pg_xlog/000000010000000000000077 > 16777216 0 0 01-25-08 21:14 > PGSData/pg_xlog/000000010000000000000078 > 16777216 0 0 02-01-08 21:19 > PGSData/pg_xlog/000000010000000000000079 > 16777216 0 0 02-01-08 21:19 > PGSData/pg_xlog/00000001000000000000007A > 16777216 0 0 02-08-08 18:41 > PGSData/pg_xlog/00000001000000000000007B > 262144 0 0 02-28-08 14:34 PGSData/pg_subtrans/0017 > 16777216 0 0 02-15-08 22:46 > PGSData/pg_xlog/00000001000000000000007C > 16777216 0 0 01-18-08 20:45 > PGSData/pg_xlog/00000001000000000000007D > 16777216 0 0 02-29-08 22:15 > PGSData/pg_xlog/00000001000000000000007E > 16777216 0 0 02-29-08 22:16 > PGSData/pg_xlog/00000001000000000000007F > 16777216 0 0 02-01-08 21:19 > PGSData/pg_xlog/000000010000000000000080 > 16777216 0 0 03-07-08 19:02 > PGSData/pg_xlog/000000010000000000000081 > 16777216 0 0 03-14-08 23:09 > PGSData/pg_xlog/000000010000000000000082 > 16777216 0 0 03-20-08 19:29 > PGSData/pg_xlog/000000010000000000000083 > 16777216 0 0 03-20-08 19:29 > PGSData/pg_xlog/000000010000000000000084 > 245760 0 0 04-11-08 11:03 PGSData/pg_subtrans/0018 > 16777216 0 0 03-28-08 19:41 > PGSData/pg_xlog/000000010000000000000085 > 16777216 0 0 03-05-08 09:58 > PGSData/pg_xlog/000000010000000000000086 > 16777216 0 0 04-04-08 21:59 > PGSData/pg_xlog/000000010000000000000087 > 16777216 0 0 04-04-08 21:59 > PGSData/pg_xlog/000000010000000000000088 > 16777216 0 0 04-18-08 18:07 > PGSData/pg_xlog/000000010000000000000089 > 16777216 0 0 04-18-08 18:08 > PGSData/pg_xlog/00000001000000000000008A > 16777216 0 0 05-02-08 19:37 > PGSData/pg_xlog/00000001000000000000008B > 16777216 0 0 05-02-08 19:37 > PGSData/pg_xlog/00000001000000000000008C > 16777216 0 0 05-09-08 21:08 > PGSData/pg_xlog/00000001000000000000008D > 16777216 0 0 05-16-08 09:17 > PGSData/pg_xlog/00000001000000000000008E > 16777216 0 0 05-23-08 22:14 > PGSData/pg_xlog/00000001000000000000008F > 253952 0 0 06-06-08 21:12 PGSData/pg_subtrans/0019 > 16777216 0 0 05-30-08 21:36 > PGSData/pg_xlog/000000010000000000000090 > 16777216 0 0 04-28-08 03:11 > PGSData/pg_xlog/000000010000000000000091 > 16777216 0 0 06-06-08 21:12 > PGSData/pg_xlog/000000010000000000000092 > 16777216 0 0 06-13-08 21:22 > PGSData/pg_xlog/000000010000000000000093 > 16777216 0 0 06-13-08 21:22 > PGSData/pg_xlog/000000010000000000000094 > 16777216 0 0 06-20-08 23:25 > PGSData/pg_xlog/000000010000000000000095 > 16777216 0 0 06-27-08 21:44 > PGSData/pg_xlog/000000010000000000000096 > 16777216 0 0 07-03-08 21:39 > PGSData/pg_xlog/000000010000000000000097 > 16777216 0 0 06-02-08 20:37 > PGSData/pg_xlog/000000010000000000000098 > 229376 0 0 07-24-08 10:30 PGSData/pg_subtrans/001A > 16777216 0 0 07-11-08 22:57 > PGSData/pg_xlog/000000010000000000000099 > 16777216 0 0 07-11-08 22:57 > PGSData/pg_xlog/00000001000000000000009A > 16777216 0 0 07-25-08 23:04 > PGSData/pg_xlog/00000001000000000000009B > 16777216 0 0 06-25-08 10:39 > PGSData/pg_xlog/00000001000000000000009C > 16777216 0 0 06-30-08 18:28 > PGSData/pg_xlog/00000001000000000000009D > 16777216 0 0 07-07-08 18:51 > PGSData/pg_xlog/00000001000000000000009E > 16777216 0 0 08-08-08 16:52 > PGSData/pg_xlog/00000001000000000000009F > 16777216 0 0 08-15-08 19:45 > PGSData/pg_xlog/0000000100000000000000A0 > 16777216 0 0 08-29-08 20:37 > PGSData/pg_xlog/0000000100000000000000A1 > 262144 0 0 09-17-08 10:14 PGSData/pg_subtrans/001B > 16777216 0 0 08-29-08 20:38 > PGSData/pg_xlog/0000000100000000000000A2 > 16777216 0 0 08-01-08 15:11 > PGSData/pg_xlog/0000000100000000000000A3 > 16777216 0 0 09-05-08 23:04 > PGSData/pg_xlog/0000000100000000000000A4 > 16777216 0 0 08-08-08 16:50 > PGSData/pg_xlog/0000000100000000000000A5 > 16777216 0 0 09-19-08 22:26 > PGSData/pg_xlog/0000000100000000000000A6 > 16777216 0 0 09-26-08 22:21 > PGSData/pg_xlog/0000000100000000000000A7 > 16777216 0 0 08-29-08 20:37 > PGSData/pg_xlog/0000000100000000000000A8 > 16777216 0 0 10-03-08 23:20 > PGSData/pg_xlog/0000000100000000000000A9 > 16777216 0 0 10-10-08 21:05 > PGSData/pg_xlog/0000000100000000000000AA > 16777216 0 0 10-17-08 23:34 > PGSData/pg_xlog/0000000100000000000000AB > 16777216 0 0 10-17-08 23:34 > PGSData/pg_xlog/0000000100000000000000AC > 262144 0 0 11-06-08 13:38 PGSData/pg_subtrans/001C > 16777216 0 0 09-23-08 14:38 > PGSData/pg_xlog/0000000100000000000000AD > 16777216 0 0 11-07-08 18:47 > PGSData/pg_xlog/0000000100000000000000AE > 16777216 0 0 11-07-08 18:48 > PGSData/pg_xlog/0000000100000000000000AF > 16777216 0 0 11-14-08 21:46 > PGSData/pg_xlog/0000000100000000000000B0 > 16777216 0 0 10-10-08 21:05 > PGSData/pg_xlog/0000000100000000000000B1 > 16777216 0 0 12-03-08 14:39 > PGSData/pg_xlog/0000000100000000000000B2 > 16777216 0 0 12-05-08 22:11 > PGSData/pg_xlog/0000000100000000000000B3 > 16777216 0 0 12-12-08 17:11 > PGSData/pg_xlog/0000000100000000000000B4 > 172032 0 0 12-12-08 13:30 PGSData/pg_subtrans/001D > 16777216 0 0 11-07-08 18:47 > PGSData/pg_xlog/0000000100000000000000B5 > 16777216 0 0 11-10-08 12:25 > PGSData/pg_xlog/0000000100000000000000B6 > 16777216 0 0 01-09-09 23:38 > PGSData/pg_xlog/0000000100000000000000B7 > 16777216 0 0 01-09-09 23:39 > PGSData/pg_xlog/0000000100000000000000B8 > 16777216 0 0 01-16-09 22:47 > PGSData/pg_xlog/0000000100000000000000B9 > 16777216 0 0 01-23-09 21:55 > PGSData/pg_xlog/0000000100000000000000BA > 245760 0 0 02-19-09 23:21 PGSData/pg_subtrans/001E > 16777216 0 0 01-30-09 21:26 > PGSData/pg_xlog/0000000100000000000000BB > 16777216 0 0 01-30-09 21:28 > PGSData/pg_xlog/0000000100000000000000BC > 16777216 0 0 02-06-09 21:06 > PGSData/pg_xlog/0000000100000000000000BD > 16777216 0 0 02-13-09 21:25 > PGSData/pg_xlog/0000000100000000000000BE > 16777216 0 0 02-13-09 21:26 > PGSData/pg_xlog/0000000100000000000000BF > 16777216 0 0 02-20-09 23:07 > PGSData/pg_xlog/0000000100000000000000C0 > 16777216 0 0 02-27-09 21:14 > PGSData/pg_xlog/0000000100000000000000C1 > 16777216 0 0 03-06-09 22:11 > PGSData/pg_xlog/0000000100000000000000C2 > 16777216 0 0 03-13-09 23:03 > PGSData/pg_xlog/0000000100000000000000C3 > 16777216 0 0 03-20-09 22:33 > PGSData/pg_xlog/0000000100000000000000C4 > 16777216 0 0 03-27-09 22:14 > PGSData/pg_xlog/0000000100000000000000C5 > 16777216 0 0 04-03-09 23:13 > PGSData/pg_xlog/0000000100000000000000C6 > 180224 0 0 04-01-09 15:36 PGSData/pg_subtrans/001F > 16777216 0 0 02-24-09 12:59 > PGSData/pg_xlog/0000000100000000000000C7 > 16777216 0 0 03-02-09 09:54 > PGSData/pg_xlog/0000000100000000000000C8 > 16777216 0 0 04-24-09 21:26 > PGSData/pg_xlog/0000000100000000000000C9 > 16777216 0 0 04-24-09 21:26 > PGSData/pg_xlog/0000000100000000000000CA > 16777216 0 0 05-01-09 21:55 > PGSData/pg_xlog/0000000100000000000000CB > 16777216 0 0 05-15-09 22:55 > PGSData/pg_xlog/0000000100000000000000CC > 262144 0 0 08-29-11 00:11 PGSData/pg_clog/0002 > 221184 0 0 06-04-09 22:23 PGSData/pg_subtrans/0020 > 16777216 0 0 05-22-09 22:06 > PGSData/pg_xlog/0000000100000000000000CD > 16777216 0 0 05-29-09 22:03 > PGSData/pg_xlog/0000000100000000000000CE > 16777216 0 0 04-20-09 10:16 > PGSData/pg_xlog/0000000100000000000000CF > 16777216 0 0 06-05-09 19:19 > PGSData/pg_xlog/0000000100000000000000D0 > 16777216 0 0 06-19-09 21:44 > PGSData/pg_xlog/0000000100000000000000D1 > 16777216 0 0 06-26-09 22:42 > PGSData/pg_xlog/0000000100000000000000D2 > 16777216 0 0 06-26-09 22:43 > PGSData/pg_xlog/0000000100000000000000D3 > 16777216 0 0 07-02-09 22:53 > PGSData/pg_xlog/0000000100000000000000D4 > 16777216 0 0 07-10-09 22:40 > PGSData/pg_xlog/0000000100000000000000D5 > 16777216 0 0 07-17-09 20:51 > PGSData/pg_xlog/0000000100000000000000D6 > 196608 0 0 07-30-09 09:34 PGSData/pg_subtrans/0021 > 16777216 0 0 07-31-09 23:40 > PGSData/pg_xlog/0000000100000000000000D7 > 16777216 0 0 06-19-09 21:44 > PGSData/pg_xlog/0000000100000000000000D8 > 16777216 0 0 08-14-09 22:09 > PGSData/pg_xlog/0000000100000000000000D9 > 16777216 0 0 08-21-09 23:13 > PGSData/pg_xlog/0000000100000000000000DA > 16777216 0 0 08-28-09 22:39 > PGSData/pg_xlog/0000000100000000000000DB > 16777216 0 0 08-28-09 22:39 > PGSData/pg_xlog/0000000100000000000000DC > 16777216 0 0 09-13-09 20:38 > PGSData/pg_xlog/0000000100000000000000DD > 253952 0 0 10-09-09 09:08 PGSData/pg_subtrans/0022 > 16777216 0 0 09-19-09 23:37 > PGSData/pg_xlog/0000000100000000000000DE > 16777216 0 0 09-25-09 22:08 > PGSData/pg_xlog/0000000100000000000000DF > 16777216 0 0 08-14-09 22:09 > PGSData/pg_xlog/0000000100000000000000E0 > 16777216 0 0 08-24-09 06:53 > PGSData/pg_xlog/0000000100000000000000E1 > 16777216 0 0 10-10-09 23:49 > PGSData/pg_xlog/0000000100000000000000E2 > 16777216 0 0 10-23-09 20:29 > PGSData/pg_xlog/0000000100000000000000E3 > 16777216 0 0 10-30-09 21:55 > PGSData/pg_xlog/0000000100000000000000E4 > 16777216 0 0 11-06-09 20:36 > PGSData/pg_xlog/0000000100000000000000E5 > 16777216 0 0 11-13-09 23:54 > PGSData/pg_xlog/0000000100000000000000E6 > 16777216 0 0 10-05-09 20:34 > PGSData/pg_xlog/0000000100000000000000E7 > 16777216 0 0 11-25-09 22:18 > PGSData/pg_xlog/0000000100000000000000E8 > 262144 0 0 12-04-09 10:56 PGSData/pg_subtrans/0023 > 16777216 0 0 10-19-09 11:49 > PGSData/pg_xlog/0000000100000000000000E9 > 16777216 0 0 12-04-09 23:22 > PGSData/pg_xlog/0000000100000000000000EA > 16777216 0 0 12-11-09 21:30 > PGSData/pg_xlog/0000000100000000000000EB > 16777216 0 0 12-23-09 17:26 > PGSData/pg_xlog/0000000100000000000000EC > 16777216 0 0 12-31-09 16:47 > PGSData/pg_xlog/0000000100000000000000ED > 16777216 0 0 12-31-09 16:48 > PGSData/pg_xlog/0000000100000000000000EE > 16777216 0 0 01-08-10 23:47 > PGSData/pg_xlog/0000000100000000000000EF > 16777216 0 0 01-15-10 21:43 > PGSData/pg_xlog/0000000100000000000000F0 > 262144 0 0 01-22-10 07:52 PGSData/pg_subtrans/0024 > 16777216 0 0 01-22-10 21:17 > PGSData/pg_xlog/0000000100000000000000F1 > 16777216 0 0 01-29-10 22:07 > PGSData/pg_xlog/0000000100000000000000F2 > 16777216 0 0 12-23-09 17:26 > PGSData/pg_xlog/0000000100000000000000F3 > 16777216 0 0 02-12-10 17:29 > PGSData/pg_xlog/0000000100000000000000F4 > 16777216 0 0 02-19-10 20:33 > PGSData/pg_xlog/0000000100000000000000F5 > 16777216 0 0 02-26-10 21:05 > PGSData/pg_xlog/0000000100000000000000F6 > 16777216 0 0 03-05-10 16:27 > PGSData/pg_xlog/0000000100000000000000F7 > 253952 0 0 03-15-10 16:48 PGSData/pg_subtrans/0025 > 16777216 0 0 03-12-10 21:11 > PGSData/pg_xlog/0000000100000000000000F8 > 16777216 0 0 03-19-10 19:09 > PGSData/pg_xlog/0000000100000000000000F9 > 16777216 0 0 03-26-10 21:55 > PGSData/pg_xlog/0000000100000000000000FA > 16777216 0 0 04-01-10 18:22 > PGSData/pg_xlog/0000000100000000000000FB > 16777216 0 0 04-09-10 21:45 > PGSData/pg_xlog/0000000100000000000000FC > 16777216 0 0 03-03-10 10:11 > PGSData/pg_xlog/0000000100000000000000FD > 16777216 0 0 04-30-10 21:25 > PGSData/pg_xlog/0000000100000000000000FE > 16777216 0 0 05-07-10 18:15 > PGSData/pg_xlog/000000010000000100000000 > 237568 0 0 05-04-10 19:04 PGSData/pg_subtrans/0026 > 16777216 0 0 05-07-10 18:15 > PGSData/pg_xlog/000000010000000100000001 > 16777216 0 0 05-14-10 23:13 > PGSData/pg_xlog/000000010000000100000002 > 16777216 0 0 04-07-10 19:00 > PGSData/pg_xlog/000000010000000100000003 > 16777216 0 0 06-04-10 21:06 > PGSData/pg_xlog/000000010000000100000004 > 16777216 0 0 06-04-10 21:07 > PGSData/pg_xlog/000000010000000100000005 > 16777216 0 0 04-30-10 21:25 > PGSData/pg_xlog/000000010000000100000006 > 237568 0 0 06-24-10 22:31 PGSData/pg_subtrans/0027 > 16777216 0 0 06-18-10 20:18 > PGSData/pg_xlog/000000010000000100000007 > 16777216 0 0 06-25-10 22:02 > PGSData/pg_xlog/000000010000000100000008 > 16777216 0 0 07-09-10 23:28 > PGSData/pg_xlog/000000010000000100000009 > 16777216 0 0 07-09-10 23:29 > PGSData/pg_xlog/00000001000000010000000A > 16777216 0 0 07-16-10 20:33 > PGSData/pg_xlog/00000001000000010000000B > 16777216 0 0 07-23-10 19:11 > PGSData/pg_xlog/00000001000000010000000C > 16777216 0 0 07-30-10 22:03 > PGSData/pg_xlog/00000001000000010000000D > 16777216 0 0 08-13-10 22:31 > PGSData/pg_xlog/00000001000000010000000E > 196608 0 0 08-12-10 17:54 PGSData/pg_subtrans/0028 > 16777216 0 0 08-13-10 22:32 > PGSData/pg_xlog/00000001000000010000000F > 16777216 0 0 07-09-10 23:28 > PGSData/pg_xlog/000000010000000100000010 > 16777216 0 0 09-04-10 22:01 > PGSData/pg_xlog/000000010000000100000011 > 16777216 0 0 09-10-10 20:35 > PGSData/pg_xlog/000000010000000100000012 > 16777216 0 0 07-26-10 18:48 > PGSData/pg_xlog/000000010000000100000013 > 16777216 0 0 09-24-10 23:43 > PGSData/pg_xlog/000000010000000100000014 > 262144 0 0 10-16-10 11:13 PGSData/pg_subtrans/0029 > 16777216 0 0 08-13-10 22:31 > PGSData/pg_xlog/000000010000000100000015 > 16777216 0 0 10-08-10 20:50 > PGSData/pg_xlog/000000010000000100000016 > 16777216 0 0 10-08-10 20:51 > PGSData/pg_xlog/000000010000000100000017 > 16777216 0 0 10-16-10 20:27 > PGSData/pg_xlog/000000010000000100000018 > 16777216 0 0 09-13-10 13:00 > PGSData/pg_xlog/000000010000000100000019 > 16777216 0 0 10-29-10 21:15 > PGSData/pg_xlog/00000001000000010000001A > 16777216 0 0 11-05-10 22:57 > PGSData/pg_xlog/00000001000000010000001B > 16777216 0 0 11-12-10 21:12 > PGSData/pg_xlog/00000001000000010000001C > 16777216 0 0 11-24-10 22:27 > PGSData/pg_xlog/00000001000000010000001D > 16777216 0 0 11-24-10 22:27 > PGSData/pg_xlog/00000001000000010000001E > 262144 0 0 12-03-10 16:38 PGSData/pg_subtrans/002A > 16777216 0 0 12-03-10 16:38 > PGSData/pg_xlog/00000001000000010000001F > 16777216 0 0 12-10-10 16:54 > PGSData/pg_xlog/000000010000000100000020 > 16777216 0 0 12-17-10 20:37 > PGSData/pg_xlog/000000010000000100000021 > 16777216 0 0 11-11-10 22:12 > PGSData/pg_xlog/000000010000000100000022 > 16777216 0 0 01-07-11 20:10 > PGSData/pg_xlog/000000010000000100000023 > 16777216 0 0 01-07-11 20:11 > PGSData/pg_xlog/000000010000000100000024 > 16777216 0 0 01-14-11 23:26 > PGSData/pg_xlog/000000010000000100000025 > 237568 0 0 01-21-11 10:51 PGSData/pg_subtrans/002B > 16777216 0 0 01-21-11 21:32 > PGSData/pg_xlog/000000010000000100000026 > 16777216 0 0 01-28-11 22:35 > PGSData/pg_xlog/000000010000000100000027 > 16777216 0 0 02-05-11 14:52 > PGSData/pg_xlog/000000010000000100000028 > 16777216 0 0 02-11-11 20:34 > PGSData/pg_xlog/000000010000000100000029 > 16777216 0 0 02-18-11 23:04 > PGSData/pg_xlog/00000001000000010000002A > 16777216 0 0 01-14-11 14:01 > PGSData/pg_xlog/00000001000000010000002B > 16777216 0 0 03-04-11 17:43 > PGSData/pg_xlog/00000001000000010000002C > 237568 0 0 03-09-11 11:35 PGSData/pg_subtrans/002C > 16777216 0 0 03-11-11 21:46 > PGSData/pg_xlog/00000001000000010000002D > 16777216 0 0 03-18-11 21:35 > PGSData/pg_xlog/00000001000000010000002E > 16777216 0 0 03-18-11 21:44 > PGSData/pg_xlog/00000001000000010000002F > 16777216 0 0 03-25-11 17:25 > PGSData/pg_xlog/000000010000000100000030 > 16777216 0 0 04-01-11 19:49 > PGSData/pg_xlog/000000010000000100000031 > 16777216 0 0 04-08-11 17:59 > PGSData/pg_xlog/000000010000000100000032 > 16777216 0 0 04-15-11 18:01 > PGSData/pg_xlog/000000010000000100000033 > 245760 0 0 04-28-11 14:31 PGSData/pg_subtrans/002D > 16777216 0 0 04-21-11 18:46 > PGSData/pg_xlog/000000010000000100000034 > 16777216 0 0 04-21-11 18:47 > PGSData/pg_xlog/000000010000000100000035 > 16777216 0 0 05-06-11 16:59 > PGSData/pg_xlog/000000010000000100000036 > 16777216 0 0 05-13-11 23:55 > PGSData/pg_xlog/000000010000000100000037 > 16777216 0 0 05-21-11 15:27 > PGSData/pg_xlog/000000010000000100000038 > 16777216 0 0 05-27-11 21:42 > PGSData/pg_xlog/000000010000000100000039 > 16777216 0 0 06-03-11 20:09 > PGSData/pg_xlog/00000001000000010000003A > 16777216 0 0 06-10-11 17:06 > PGSData/pg_xlog/00000001000000010000003B > 16777216 0 0 06-17-11 19:06 > PGSData/pg_xlog/00000001000000010000003C > 262144 0 0 06-30-11 14:19 PGSData/pg_subtrans/002E > 16777216 0 0 06-24-11 16:53 > PGSData/pg_xlog/00000001000000010000003D > 16777216 0 0 07-01-11 21:33 > PGSData/pg_xlog/00000001000000010000003E > 16777216 0 0 07-08-11 17:20 > PGSData/pg_xlog/00000001000000010000003F > 16777216 0 0 07-15-11 16:34 > PGSData/pg_xlog/000000010000000100000040 > 16777216 0 0 07-22-11 20:04 > PGSData/pg_xlog/000000010000000100000041 > 16777216 0 0 07-29-11 16:03 > PGSData/pg_xlog/000000010000000100000042 > 16777216 0 0 08-05-11 18:30 > PGSData/pg_xlog/000000010000000100000043 > 16777216 0 0 08-12-11 17:13 > PGSData/pg_xlog/000000010000000100000044 > 262144 0 0 08-26-11 11:20 PGSData/pg_subtrans/002F > 16777216 0 0 08-19-11 20:38 > PGSData/pg_xlog/000000010000000100000045 > 16777216 0 0 08-26-11 20:20 > PGSData/pg_xlog/000000010000000100000046 > 16777216 0 0 09-02-11 18:03 > PGSData/pg_xlog/000000010000000100000047 > 16777216 0 0 09-09-11 21:04 > PGSData/pg_xlog/000000010000000100000048 > 16777216 0 0 09-16-11 17:33 > PGSData/pg_xlog/000000010000000100000049 > 16777216 0 0 09-23-11 16:52 > PGSData/pg_xlog/00000001000000010000004A > 16777216 0 0 09-23-11 16:53 > PGSData/pg_xlog/00000001000000010000004B > 16777216 0 0 09-30-11 21:20 > PGSData/pg_xlog/00000001000000010000004C > 245760 0 0 05-10-13 13:51 PGSData/pg_clog/0003 > 229376 0 0 10-05-11 10:51 PGSData/pg_subtrans/0030 > 16777216 0 0 10-07-11 20:52 > PGSData/pg_xlog/00000001000000010000004D > 16777216 0 0 10-14-11 20:15 > PGSData/pg_xlog/00000001000000010000004E > 16777216 0 0 10-14-11 20:16 > PGSData/pg_xlog/00000001000000010000004F > 16777216 0 0 10-28-11 18:45 > PGSData/pg_xlog/000000010000000100000050 > 16777216 0 0 10-28-11 18:47 > PGSData/pg_xlog/000000010000000100000051 > 16777216 0 0 11-04-11 21:04 > PGSData/pg_xlog/000000010000000100000052 > 16777216 0 0 09-30-11 21:20 > PGSData/pg_xlog/000000010000000100000053 > 245760 0 0 11-23-11 18:32 PGSData/pg_subtrans/0031 > 16777216 0 0 10-10-11 04:34 > PGSData/pg_xlog/000000010000000100000054 > 16777216 0 0 11-24-11 01:52 > PGSData/pg_xlog/000000010000000100000055 > 16777216 0 0 11-24-11 01:53 > PGSData/pg_xlog/000000010000000100000056 > 16777216 0 0 12-09-11 20:16 > PGSData/pg_xlog/000000010000000100000057 > 16777216 0 0 12-09-11 20:18 > PGSData/pg_xlog/000000010000000100000058 > 16777216 0 0 12-17-11 17:18 > PGSData/pg_xlog/000000010000000100000059 > 16777216 0 0 12-22-11 17:28 > PGSData/pg_xlog/00000001000000010000005A > 16777216 0 0 12-30-11 22:00 > PGSData/pg_xlog/00000001000000010000005B > 237568 0 0 01-12-12 13:31 PGSData/pg_subtrans/0032 > 16777216 0 0 11-24-11 01:52 > PGSData/pg_xlog/00000001000000010000005C > 16777216 0 0 01-14-12 17:49 > PGSData/pg_xlog/00000001000000010000005D > 16777216 0 0 01-21-12 19:12 > PGSData/pg_xlog/00000001000000010000005E > 16777216 0 0 12-15-11 10:06 > PGSData/pg_xlog/00000001000000010000005F > 16777216 0 0 01-28-12 15:39 > PGSData/pg_xlog/000000010000000100000060 > 16777216 0 0 12-23-11 17:35 > PGSData/pg_xlog/000000010000000100000061 > 16777216 0 0 02-10-12 17:03 > PGSData/pg_xlog/000000010000000100000062 > 16777216 0 0 02-10-12 17:05 > PGSData/pg_xlog/000000010000000100000063 > 245760 0 0 02-24-12 13:56 PGSData/pg_subtrans/0033 > 16777216 0 0 01-16-12 19:06 > PGSData/pg_xlog/000000010000000100000064 > 16777216 0 0 02-24-12 16:00 > PGSData/pg_xlog/000000010000000100000065 > 16777216 0 0 01-27-12 02:02 > PGSData/pg_xlog/000000010000000100000066 > 16777216 0 0 01-30-12 01:16 > PGSData/pg_xlog/000000010000000100000067 > 16777216 0 0 03-09-12 21:21 > PGSData/pg_xlog/000000010000000100000068 > 16777216 0 0 02-10-12 17:03 > PGSData/pg_xlog/000000010000000100000069 > 16777216 0 0 03-25-12 00:43 > PGSData/pg_xlog/00000001000000010000006A > 16777216 0 0 03-25-12 00:45 > PGSData/pg_xlog/00000001000000010000006B > 237568 0 0 04-02-12 06:30 PGSData/pg_subtrans/0034 > 16777216 0 0 04-05-12 21:12 > PGSData/pg_xlog/00000001000000010000006C > 16777216 0 0 04-05-12 21:13 > PGSData/pg_xlog/00000001000000010000006D > 16777216 0 0 03-09-12 10:36 > PGSData/pg_xlog/00000001000000010000006E > 16777216 0 0 04-20-12 20:18 > PGSData/pg_xlog/00000001000000010000006F > 16777216 0 0 04-20-12 20:19 > PGSData/pg_xlog/000000010000000100000070 > 16777216 0 0 03-25-12 00:43 > PGSData/pg_xlog/000000010000000100000071 > 16777216 0 0 03-29-12 12:03 > PGSData/pg_xlog/000000010000000100000072 > 221184 0 0 05-11-12 13:32 PGSData/pg_subtrans/0035 > 16777216 0 0 05-11-12 21:28 > PGSData/pg_xlog/000000010000000100000073 > 16777216 0 0 04-12-12 08:41 > PGSData/pg_xlog/000000010000000100000074 > 16777216 0 0 04-17-12 14:29 > PGSData/pg_xlog/000000010000000100000075 > 16777216 0 0 04-20-12 20:18 > PGSData/pg_xlog/000000010000000100000076 > 16777216 0 0 06-03-12 00:33 > PGSData/pg_xlog/000000010000000100000077 > 16777216 0 0 05-05-12 13:45 > PGSData/pg_xlog/000000010000000100000078 > 16777216 0 0 05-11-12 10:35 > PGSData/pg_xlog/000000010000000100000079 > 253952 0 0 06-22-12 12:43 PGSData/pg_subtrans/0036 > 16777216 0 0 05-12-12 08:57 > PGSData/pg_xlog/00000001000000010000007A > 16777216 0 0 06-15-12 21:06 > PGSData/pg_xlog/00000001000000010000007B > 16777216 0 0 06-15-12 21:07 > PGSData/pg_xlog/00000001000000010000007C > 16777216 0 0 06-22-12 17:39 > PGSData/pg_xlog/00000001000000010000007D > 16777216 0 0 06-04-12 00:59 > PGSData/pg_xlog/00000001000000010000007E > 16777216 0 0 07-06-12 18:50 > PGSData/pg_xlog/00000001000000010000007F > 16777216 0 0 07-06-12 18:52 > PGSData/pg_xlog/000000010000000100000080 > 16777216 0 0 07-13-12 23:50 > PGSData/pg_xlog/000000010000000100000081 > 16777216 0 0 07-21-12 19:15 > PGSData/pg_xlog/000000010000000100000082 > 16777216 0 0 07-27-12 22:54 > PGSData/pg_xlog/000000010000000100000083 > 196608 0 0 07-26-12 08:01 PGSData/pg_subtrans/0037 > 16777216 0 0 07-27-12 22:56 > PGSData/pg_xlog/000000010000000100000084 > 16777216 0 0 06-29-12 21:07 > PGSData/pg_xlog/000000010000000100000085 > 16777216 0 0 08-10-12 20:13 > PGSData/pg_xlog/000000010000000100000086 > 16777216 0 0 08-10-12 20:15 > PGSData/pg_xlog/000000010000000100000087 > 16777216 0 0 08-17-12 20:23 > PGSData/pg_xlog/000000010000000100000088 > 16777216 0 0 08-24-12 16:06 > PGSData/pg_xlog/000000010000000100000089 > 253952 0 0 09-13-12 14:41 PGSData/pg_subtrans/0038 > 16777216 0 0 08-24-12 16:07 > PGSData/pg_xlog/00000001000000010000008A > 16777216 0 0 08-31-12 20:19 > PGSData/pg_xlog/00000001000000010000008B > 16777216 0 0 09-07-12 22:42 > PGSData/pg_xlog/00000001000000010000008C > 16777216 0 0 09-14-12 21:21 > PGSData/pg_xlog/00000001000000010000008D > 16777216 0 0 09-21-12 18:23 > PGSData/pg_xlog/00000001000000010000008E > 16777216 0 0 09-28-12 15:37 > PGSData/pg_xlog/00000001000000010000008F > 16777216 0 0 09-28-12 15:38 > PGSData/pg_xlog/000000010000000100000090 > 16777216 0 0 10-05-12 18:50 > PGSData/pg_xlog/000000010000000100000091 > 16777216 0 0 10-12-12 17:41 > PGSData/pg_xlog/000000010000000100000092 > 16777216 0 0 09-10-12 11:08 > PGSData/pg_xlog/000000010000000100000093 > 253952 0 0 10-25-12 13:29 PGSData/pg_subtrans/0039 > 16777216 0 0 10-24-12 16:35 > PGSData/pg_xlog/000000010000000100000094 > 16777216 0 0 10-31-12 17:17 > PGSData/pg_xlog/000000010000000100000095 > 16777216 0 0 11-02-12 23:03 > PGSData/pg_xlog/000000010000000100000096 > 16777216 0 0 11-09-12 17:08 > PGSData/pg_xlog/000000010000000100000097 > 16777216 0 0 11-09-12 17:10 > PGSData/pg_xlog/000000010000000100000098 > 16777216 0 0 11-16-12 17:47 > PGSData/pg_xlog/000000010000000100000099 > 16777216 0 0 10-22-12 16:58 > PGSData/pg_xlog/00000001000000010000009A > 16777216 0 0 11-26-12 20:24 > PGSData/pg_xlog/00000001000000010000009B > 253952 0 0 12-07-12 21:45 PGSData/pg_subtrans/003A > 16777216 0 0 12-07-12 21:44 > PGSData/pg_xlog/00000001000000010000009C > 16777216 0 0 12-07-12 21:45 > PGSData/pg_xlog/00000001000000010000009D > 16777216 0 0 12-14-12 20:45 > PGSData/pg_xlog/00000001000000010000009E > 16777216 0 0 12-21-12 23:14 > PGSData/pg_xlog/00000001000000010000009F > 16777216 0 0 12-29-12 20:43 > PGSData/pg_xlog/0000000100000001000000A0 > 16777216 0 0 11-26-12 20:23 > PGSData/pg_xlog/0000000100000001000000A1 > 16777216 0 0 01-12-13 00:17 > PGSData/pg_xlog/0000000100000001000000A2 > 237568 0 0 01-18-13 10:46 PGSData/pg_subtrans/003B > 16777216 0 0 01-19-13 00:28 > PGSData/pg_xlog/0000000100000001000000A3 > 16777216 0 0 12-14-12 11:03 > PGSData/pg_xlog/0000000100000001000000A4 > 16777216 0 0 01-25-13 17:45 > PGSData/pg_xlog/0000000100000001000000A5 > 16777216 0 0 02-01-13 19:12 > PGSData/pg_xlog/0000000100000001000000A6 > 16777216 0 0 02-01-13 19:14 > PGSData/pg_xlog/0000000100000001000000A7 > 16777216 0 0 02-08-13 16:28 > PGSData/pg_xlog/0000000100000001000000A8 > 16777216 0 0 02-15-13 17:10 > PGSData/pg_xlog/0000000100000001000000A9 > 253952 0 0 03-01-13 10:37 PGSData/pg_subtrans/003C > 16777216 0 0 02-22-13 17:16 > PGSData/pg_xlog/0000000100000001000000AA > 16777216 0 0 02-22-13 17:18 > PGSData/pg_xlog/0000000100000001000000AB > 16777216 0 0 03-01-13 16:43 > PGSData/pg_xlog/0000000100000001000000AC > 16777216 0 0 03-08-13 16:08 > PGSData/pg_xlog/0000000100000001000000AD > 16777216 0 0 03-15-13 18:18 > PGSData/pg_xlog/0000000100000001000000AE > 16777216 0 0 02-12-13 01:37 > PGSData/pg_xlog/0000000100000001000000AF > 16777216 0 0 03-22-13 19:14 > PGSData/pg_xlog/0000000100000001000000B0 > 16777216 0 0 03-28-13 21:13 > PGSData/pg_xlog/0000000100000001000000B1 > 16777216 0 0 04-05-13 19:38 > PGSData/pg_xlog/0000000100000001000000B2 > 253952 0 0 04-12-13 17:50 PGSData/pg_subtrans/003D > 16777216 0 0 04-05-13 19:45 > PGSData/pg_xlog/0000000100000001000000B3 > 16777216 0 0 04-12-13 17:50 > PGSData/pg_xlog/0000000100000001000000B4 > 16777216 0 0 04-20-13 00:10 > PGSData/pg_xlog/0000000100000001000000B5 > 16777216 0 0 04-25-13 20:34 > PGSData/pg_xlog/0000000100000001000000B6 > 16777216 0 0 05-03-13 20:51 > PGSData/pg_xlog/0000000100000001000000B7 > 16777216 0 0 05-03-13 20:52 > PGSData/pg_xlog/0000000100000001000000B8 > 16777216 0 0 05-10-13 11:35 > PGSData/pg_xlog/0000000100000001000000B9 > 16777216 0 0 05-10-13 13:51 > PGSData/pg_xlog/0000000100000001000000BA > 163840 0 0 05-10-13 13:51 PGSData/pg_subtrans/003E > 16777216 0 0 04-16-13 10:47 > PGSData/pg_xlog/0000000100000001000000BB > 16777216 0 0 04-23-13 08:54 > PGSData/pg_xlog/0000000100000001000000BC > 16777216 0 0 04-29-13 06:23 > PGSData/pg_xlog/0000000100000001000000BD > 16777216 0 0 05-03-13 20:51 > PGSData/pg_xlog/0000000100000001000000BE > 16777216 0 0 05-06-13 14:12 > PGSData/pg_xlog/0000000100000001000000BF > 16777216 0 0 05-10-13 11:35 > PGSData/pg_xlog/0000000100000001000000C0 > -------- ----- ----- ------- > > Total = 5.7315E+09 bytes > > > > Amit Langote wrote: >> Hello John, >> >> Those are Write Ahead Log (WAL) file segments (16MB each) and are part >> of PostgreSQL's REDO mechanism. >> PostgreSQL official documentation on WAL: >> >> http://www.postgresql.org/docs/9.2/static/wal.html >> >>> 1. Can I delete them and still continue to run? >> >> You would not be able to recover if you deleted the segments that >> PostgreSQL would require for recovery. That is, if you delete WAL >> segments after the last checkpoint, you would not be able to recover >> consistently. Note that a checkpoint is a point in database operation, >> all the data changes before which, are guaranteed to be written out to >> data files (hence consistent). So, all the WAL data after the last >> checkpoint is essential for consistent should the database crash, >> since the data changes (that this WAL data represents) have not made >> to the data files yet. Though, you wouldn't require any of WAL data >> before a checkpoint (though, you may still keep old WAL files in an >> archive directory different than pg_xlog to later perform a >> Point-in-Time-Recovery). >> >>> 2. How do I turn off the generation of these files? >> >> You can not turn off generation of these files. They are an integral >> part of consistent database operation that ensure integrity and crash >> safety. Though, you may control the number of such segments under >> pg_xlog. I would recommend you read PostgreSQL documentation about >> ways to do this. >> >> >> -- >> Amit Langote >> >> > Please do not top post. It is the convention on this list to bottom post, so that people can read what went before. Hence top posting is considered outrageous! I think people would need some idea of what kind of things you are doing with the database, plus a measure of its load in terms of concurrent transactions and transactions per second - before they'd worry too much about the size of th wAL files. Especially since individual disks are now often at least a Terabyte, so 7 Gigabytes is only 0.7 % of that, and the WAL plays a crucial part in what a database does to protect your data. Also what else is the machine used for, ... It would be good also to mention the operating system and version of Postgres. Cheers, Gavin
jjurban <jjurban@attglobal.net> wrote: > Amit Langote wrote: > There are over 5.7 Gigabytes of these files. This cannot be > correct. That depends entirely on your configuration. In some environments that would be excessive; in others it might be just right. > Which of these can I remove? It is a bad idea to remove any of them yourself. If you configure PostgreSQL to keep fewer of them, the unneeded ones according to your new configuration should get cleaned up fairly quickly. >> Those are Write Ahead Log (WAL) file segments (16MB each) and >> are part of PostgreSQL's REDO mechanism. >> PostgreSQL official documentation on WAL: >> >> http://www.postgresql.org/docs/9.2/static/wal.html > What can I do to avoid generating these monstrous files? Read the referenced documentation. Primarily you will be interested in checkpoint_segments, wal_keep_segments, and settings related to archiving -- since if archiving is turned on these files must be kept in the pg_xlog directory until successfully archived. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Kevin Grittner wrote: > jjurban <jjurban@attglobal.net> wrote: > >> Amit Langote wrote: >> > > >> There are over 5.7 Gigabytes of these files. This cannot be >> correct. >> > > That depends entirely on your configuration. In some environments > that would be excessive; in others it might be just right. > Here's what I did - I checked those pg_xlog files and discovered that the last 2 entries in the pg_subtrans directory had dates of 4/12/2013 and 5/10/2013 - are these considered "checkpoints?" Then I deleted ALL of the 16+ MB files in pg_xlog with dates BEFORE 4/12/2013. My system seems to run OK now. But size-wise, the total disk storage required is only 800MB now, whereas before I deleted all those pg_xlog files, the size was 6.5 GB. I realize that you can get terabyte drives now, but I still believe that one shouldn't waste computer resources if possible. I read in the reference you provided "Any changes made to data files before that point [the last checkpoint?] are guaranteed to be already on disk. Hence, after a checkpoint, log segments preceding the one containing the redo record are no longer needed and can be recycled or removed. (When WAL archiving is being done, the log segments must be archived before being recycled or removed.)" So I assume that my deletion did no harm. By the way, I am running version 8.0 on eComStation. I know that everyone will jump on me and demand that I upgrade to the latest, but 8.0 has always worked fine for me and I don't have dlls to enable Rexx - PGS interface for later versions. I still am not clear on what I have to do to avoid generating these big files that I really don't need. I don't want to do archiving and I always back up by simply zipping my PGSData folder. Thanks again, John > >> Which of these can I remove? >> > > It is a bad idea to remove any of them yourself. If you configure > PostgreSQL to keep fewer of them, the unneeded ones according to > your new configuration should get cleaned up fairly quickly. > > >>> Those are Write Ahead Log (WAL) file segments (16MB each) and >>> are part of PostgreSQL's REDO mechanism. >>> PostgreSQL official documentation on WAL: >>> >>> http://www.postgresql.org/docs/9.2/static/wal.html >>> > > >> What can I do to avoid generating these monstrous files? >> > > Read the referenced documentation. Primarily you will be > interested in checkpoint_segments, wal_keep_segments, and settings > related to archiving -- since if archiving is turned on these files > must be kept in the pg_xlog directory until successfully archived. > > -- > Kevin Grittner > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > >
On Fri, May 17, 2013 at 12:19 AM, jjurban <jjurban@attglobal.net> wrote: > Kevin Grittner wrote: >> >> jjurban <jjurban@attglobal.net> wrote: >> >>> >>> Amit Langote wrote: >>> >> >> >> >>> >>> There are over 5.7 Gigabytes of these files. This cannot be >>> correct. >>> >> >> >> That depends entirely on your configuration. In some environments >> that would be excessive; in others it might be just right. >> > > > > Here's what I did - I checked those pg_xlog files and discovered that the > last 2 entries in the pg_subtrans directory had dates of 4/12/2013 and > 5/10/2013 - are these considered "checkpoints?" You can see the last checkpoint using pg_controldata program. You can pass to it the path of your data directory and it tells (among other things) the latest checkpoint location or rather latest checkpoint's REDO location. http://www.postgresql.org/docs/8.0/static/app-pgcontroldata.html You can copy that location and use an administrative xlog function to see which WAL segment file it is contained it and safely delete all the files before that file. A sample use of that function: [amit@amit-centos64 pgbench]$ ls ~/pgdata/pg/pg_xlog/ 00000001000000000000001F 000000010000000000000021 000000010000000000000023 000000010000000000000025 archive_status 000000010000000000000020 000000010000000000000022 000000010000000000000024 000000010000000000000026 [amit@amit-centos64 pgbench]$ pg_controldata ~/pgdata/pg | head -n 9 pg_control version number: 937 Catalog version number: 201305061 Database system identifier: 5878462236927524454 Database cluster state: in production pg_control last modified: Fri 17 May 2013 09:34:09 AM JST Latest checkpoint location: 0/2384D628 Prior checkpoint location: 0/208F1830 Latest checkpoint's REDO location: 0/22005E38 Latest checkpoint's REDO WAL file: 000000010000000000000022 [amit@amit-centos64 pgbench]$ psql -d postgres -c "select pg_xlogfile_name('0/22005E38')" Password: pg_xlogfile_name -------------------------- 000000010000000000000022 (1 row) So that I can safely delete 00000001000000000000001F, 000000010000000000000020 and 000000010000000000000021 or under proper configuration they would be recycled or deleted by PostgreSQL itself. You need to be cautious here not to use the file modified times from ls listing to make that decision, since, some of the previous files are possibly recycled from the old segment files which you otherwise would have deleted). I suggest you rather read a bit about how WAL segments are named so that you can understand which ones are *before* a given file and can safely be deleted. In fact proper WAL configurtion based on your workload requirements would never require you to bother yourself with this manual process, since, PostgreSQL itself takes care of keeping the pg_xlog clean. I have found this article to be useful to learn about WAL: http://www.depesz.com/2011/07/14/write-ahead-log-understanding-postgresql-conf-checkpoint_segments-checkpoint_timeout-checkpoint_warning/ > > I still am not clear on what I have to do to avoid generating these big > files that I really don't need. I don't want to do archiving and I always > back up by simply zipping my PGSData folder. > Well, depending on your crash safety requirements you would want to keep at least *some* of the WAL around by proper configuration. With no archiving (archive_mode=off), you would want to keep wal_keep_segments to a decent value for crash safety. You are taking backups anyway, so keeping WAL around would always help to recover if need be. You would want to have a look at checkpoint_segments, which decides both how often checkpoints happen and and also how many WAL segments pg_xlog would contain at any given time, though exact formula to calculate that number is different). Do read the references from which you will get an idea as to what it all means and what is needed to accomplish what you are trying to without risking safety of your own data. Amit Langote