Re: log files - Mailing list pgsql-novice
From | Gavin Flower |
---|---|
Subject | Re: log files |
Date | |
Msg-id | 5193E75E.7090803@archidevsys.co.nz Whole thread Raw |
In response to | Re: log files (jjurban <jjurban@attglobal.net>) |
List | pgsql-novice |
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
pgsql-novice by date: