RE: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"

From: Fan Liu <fan(dot)liu(at)ericsson(dot)com>
To: "depesz(at)depesz(dot)com" <depesz(at)depesz(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #16317: max_wal_size does not remove WAL files, cause "no space left"
Date: 2020-03-26 11:11:28
Message-ID: HE1PR0701MB25694946641F8707C9C505DD9ECF0@HE1PR0701MB2569.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I have to clean up some space today, so I removed some WAL from Feb.
But the issue is still there, WAL keep increasing.

-------------- LOG -----------------------------------------------------------------------------------
postgres=# select pg_walfile_name( pg_current_wal_lsn());
DEBUG: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0
DEBUG: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0
pg_walfile_name
--------------------------
000000F30000000000000009
(1 row)

postgres=#

db-pg-0:/var/lib/postgresql/data/pgdata # ls -alh pg_wal/
total 2.3G
drwx------ 3 postgres postgres 20K Mar 26 10:56 .
drwx------ 19 postgres postgres 4.0K Mar 26 09:32 ..
-rw------- 1 postgres postgres 16M Mar 2 08:46 000000680000000000000005
-rw------- 1 postgres postgres 16M Mar 2 12:07 000000690000000000000005
-rw------- 1 postgres postgres 4.4K Mar 2 08:46 00000069.history
-rw------- 1 postgres postgres 16M Mar 2 12:17 0000006A0000000000000005
-rw------- 1 postgres postgres 4.5K Mar 2 12:07 0000006A.history
-rw------- 1 postgres postgres 16M Mar 2 12:46 0000006B0000000000000005
-rw------- 1 postgres postgres 4.5K Mar 2 12:17 0000006B.history
-rw------- 1 postgres postgres 16M Mar 2 18:55 0000006C0000000000000005
-rw------- 1 postgres postgres 4.5K Mar 2 12:46 0000006C.history
-rw------- 1 postgres postgres 16M Mar 2 19:03 0000006D0000000000000005
-rw------- 1 postgres postgres 4.6K Mar 2 18:55 0000006D.history
-rw------- 1 postgres postgres 16M Mar 2 19:28 0000006E0000000000000005
-rw------- 1 postgres postgres 4.6K Mar 2 19:03 0000006E.history
-rw------- 1 postgres postgres 16M Mar 2 19:36 0000006F0000000000000005
-rw------- 1 postgres postgres 4.7K Mar 2 19:28 0000006F.history
-rw------- 1 postgres postgres 16M Mar 2 19:42 000000700000000000000005
-rw------- 1 postgres postgres 4.7K Mar 2 19:37 00000070.history
-rw------- 1 postgres postgres 16M Mar 2 19:53 000000710000000000000005
-rw------- 1 postgres postgres 4.8K Mar 2 19:42 00000071.history
-rw------- 1 postgres postgres 16M Mar 2 20:08 000000720000000000000005
-rw------- 1 postgres postgres 4.8K Mar 2 19:54 00000072.history
-rw------- 1 postgres postgres 16M Mar 2 21:22 000000730000000000000005
-rw------- 1 postgres postgres 4.8K Mar 2 20:08 00000073.history
-rw------- 1 postgres postgres 16M Mar 2 21:31 000000740000000000000005
-rw------- 1 postgres postgres 4.9K Mar 2 21:22 00000074.history
-rw------- 1 postgres postgres 16M Mar 2 21:41 000000750000000000000005
-rw------- 1 postgres postgres 4.9K Mar 2 21:31 00000075.history
-rw------- 1 postgres postgres 16M Mar 2 21:48 000000760000000000000005
-rw------- 1 postgres postgres 5.0K Mar 2 21:41 00000076.history
-rw------- 1 postgres postgres 16M Mar 2 22:07 000000770000000000000005
-rw------- 1 postgres postgres 5.0K Mar 2 21:49 00000077.history
-rw------- 1 postgres postgres 16M Mar 2 22:45 000000780000000000000005
-rw------- 1 postgres postgres 5.1K Mar 2 22:07 00000078.history
-rw------- 1 postgres postgres 16M Mar 2 23:04 000000790000000000000005
-rw------- 1 postgres postgres 5.1K Mar 2 22:45 00000079.history
-rw------- 1 postgres postgres 16M Mar 2 23:31 0000007A0000000000000005
-rw------- 1 postgres postgres 5.1K Mar 2 23:04 0000007A.history
-rw------- 1 postgres postgres 16M Mar 3 00:06 0000007B0000000000000005
-rw------- 1 postgres postgres 5.2K Mar 2 23:31 0000007B.history
-rw------- 1 postgres postgres 16M Mar 3 02:01 0000007C0000000000000005
-rw------- 1 postgres postgres 5.2K Mar 3 00:06 0000007C.history
-rw------- 1 postgres postgres 16M Mar 3 03:14 0000007D0000000000000005
-rw------- 1 postgres postgres 5.3K Mar 3 02:01 0000007D.history
-rw------- 1 postgres postgres 16M Mar 3 08:12 0000007E0000000000000005
-rw------- 1 postgres postgres 5.3K Mar 3 03:14 0000007E.history
-rw------- 1 postgres postgres 16M Mar 3 10:19 0000007F0000000000000005
-rw------- 1 postgres postgres 5.4K Mar 3 08:12 0000007F.history
-rw------- 1 postgres postgres 16M Mar 3 11:28 000000800000000000000005
-rw------- 1 postgres postgres 5.4K Mar 3 10:19 00000080.history
-rw------- 1 postgres postgres 16M Mar 3 12:00 000000810000000000000005
-rw------- 1 postgres postgres 5.4K Mar 3 11:28 00000081.history
-rw------- 1 postgres postgres 16M Mar 3 12:41 000000820000000000000005
-rw------- 1 postgres postgres 5.5K Mar 3 12:00 00000082.history
-rw------- 1 postgres postgres 16M Mar 3 12:49 000000830000000000000005
-rw------- 1 postgres postgres 5.5K Mar 3 12:41 00000083.history
-rw------- 1 postgres postgres 16M Mar 3 14:10 000000840000000000000005
-rw------- 1 postgres postgres 5.6K Mar 3 12:49 00000084.history
-rw------- 1 postgres postgres 16M Mar 3 14:40 000000850000000000000005
-rw------- 1 postgres postgres 5.6K Mar 3 14:10 00000085.history
-rw------- 1 postgres postgres 16M Mar 3 14:48 000000860000000000000005
-rw------- 1 postgres postgres 5.7K Mar 3 14:40 00000086.history
-rw------- 1 postgres postgres 16M Mar 3 15:25 000000870000000000000005
-rw------- 1 postgres postgres 5.7K Mar 3 14:48 00000087.history
-rw------- 1 postgres postgres 16M Mar 3 15:56 000000880000000000000005
-rw------- 1 postgres postgres 5.7K Mar 3 15:25 00000088.history
-rw------- 1 postgres postgres 16M Mar 3 16:34 000000890000000000000005
-rw------- 1 postgres postgres 5.8K Mar 3 15:57 00000089.history
-rw------- 1 postgres postgres 16M Mar 3 16:36 0000008A0000000000000005
-rw------- 1 postgres postgres 5.8K Mar 3 16:34 0000008A.history
-rw------- 1 postgres postgres 16M Mar 3 16:37 0000008B0000000000000005
-rw------- 1 postgres postgres 5.9K Mar 3 16:36 0000008B.history
-rw------- 1 postgres postgres 16M Mar 3 16:42 0000008C0000000000000005
-rw------- 1 postgres postgres 5.9K Mar 3 16:38 0000008C.history
-rw------- 1 postgres postgres 16M Mar 3 16:44 0000008D0000000000000005
-rw------- 1 postgres postgres 6.0K Mar 3 16:42 0000008D.history
-rw------- 1 postgres postgres 16M Mar 3 16:45 0000008E0000000000000005
-rw------- 1 postgres postgres 6.0K Mar 3 16:44 0000008E.history
-rw------- 1 postgres postgres 16M Mar 3 16:56 0000008F0000000000000005
-rw------- 1 postgres postgres 6.0K Mar 3 16:45 0000008F.history
-rw------- 1 postgres postgres 16M Mar 3 17:01 000000900000000000000005
-rw------- 1 postgres postgres 6.1K Mar 3 16:56 00000090.history
-rw------- 1 postgres postgres 16M Mar 3 17:04 000000910000000000000005
-rw------- 1 postgres postgres 6.1K Mar 3 17:01 00000091.history
-rw------- 1 postgres postgres 16M Mar 3 17:55 000000920000000000000005
-rw------- 1 postgres postgres 6.2K Mar 3 17:04 00000092.history
-rw------- 1 postgres postgres 16M Mar 3 18:04 000000930000000000000005
-rw------- 1 postgres postgres 6.2K Mar 3 17:55 00000093.history
-rw------- 1 postgres postgres 16M Mar 3 18:13 000000940000000000000005
-rw------- 1 postgres postgres 6.3K Mar 3 18:04 00000094.history
-rw------- 1 postgres postgres 16M Mar 3 19:27 000000950000000000000005
-rw------- 1 postgres postgres 6.3K Mar 3 18:13 00000095.history
-rw------- 1 postgres postgres 16M Mar 3 20:20 000000960000000000000005
-rw------- 1 postgres postgres 6.3K Mar 3 19:27 00000096.history
-rw------- 1 postgres postgres 16M Mar 3 21:31 000000970000000000000005
-rw------- 1 postgres postgres 6.4K Mar 3 20:20 00000097.history
-rw------- 1 postgres postgres 16M Mar 3 22:38 000000980000000000000005
-rw------- 1 postgres postgres 6.4K Mar 3 21:31 00000098.history
-rw------- 1 postgres postgres 16M Mar 4 07:25 000000990000000000000005
-rw------- 1 postgres postgres 6.5K Mar 3 22:38 00000099.history
-rw------- 1 postgres postgres 16M Mar 4 08:06 0000009A0000000000000005
-rw------- 1 postgres postgres 6.5K Mar 4 07:25 0000009A.history
-rw------- 1 postgres postgres 16M Mar 4 11:09 0000009B0000000000000005
-rw------- 1 postgres postgres 6.6K Mar 4 08:06 0000009B.history
-rw------- 1 postgres postgres 16M Mar 4 11:38 0000009C0000000000000005
-rw------- 1 postgres postgres 6.6K Mar 4 11:09 0000009C.history
-rw------- 1 postgres postgres 16M Mar 4 11:54 0000009D0000000000000005
-rw------- 1 postgres postgres 6.6K Mar 4 11:38 0000009D.history
-rw------- 1 postgres postgres 16M Mar 4 13:57 0000009E0000000000000005
-rw------- 1 postgres postgres 6.7K Mar 4 11:54 0000009E.history
-rw------- 1 postgres postgres 16M Mar 4 14:19 0000009F0000000000000005
-rw------- 1 postgres postgres 6.7K Mar 4 13:57 0000009F.history
-rw------- 1 postgres postgres 16M Mar 4 14:25 000000A00000000000000005
-rw------- 1 postgres postgres 6.8K Mar 4 14:19 000000A0.history
-rw------- 1 postgres postgres 16M Mar 4 14:27 000000A10000000000000005
-rw------- 1 postgres postgres 6.8K Mar 4 14:25 000000A1.history
-rw------- 1 postgres postgres 16M Mar 4 14:56 000000A20000000000000005
-rw------- 1 postgres postgres 6.9K Mar 4 14:27 000000A2.history
-rw------- 1 postgres postgres 16M Mar 4 15:47 000000A30000000000000005
-rw------- 1 postgres postgres 6.9K Mar 4 14:56 000000A3.history
-rw------- 1 postgres postgres 16M Mar 4 15:48 000000A40000000000000005
-rw------- 1 postgres postgres 6.9K Mar 4 15:47 000000A4.history
-rw------- 1 postgres postgres 16M Mar 4 16:24 000000A50000000000000005
-rw------- 1 postgres postgres 7.0K Mar 4 15:48 000000A5.history
-rw------- 1 postgres postgres 16M Mar 4 16:31 000000A60000000000000005
-rw------- 1 postgres postgres 7.0K Mar 4 16:24 000000A6.history
-rw------- 1 postgres postgres 16M Mar 4 16:33 000000A70000000000000005
-rw------- 1 postgres postgres 7.1K Mar 4 16:31 000000A7.history
-rw------- 1 postgres postgres 16M Mar 4 16:40 000000A80000000000000005
-rw------- 1 postgres postgres 7.1K Mar 4 16:33 000000A8.history
-rw------- 1 postgres postgres 16M Mar 4 17:00 000000A90000000000000005
-rw------- 1 postgres postgres 7.2K Mar 4 16:40 000000A9.history
-rw------- 1 postgres postgres 16M Mar 4 17:20 000000AA0000000000000005
-rw------- 1 postgres postgres 7.2K Mar 4 17:00 000000AA.history
-rw------- 1 postgres postgres 16M Mar 4 17:47 000000AB0000000000000005
-rw------- 1 postgres postgres 7.2K Mar 4 17:20 000000AB.history
-rw------- 1 postgres postgres 16M Mar 4 17:49 000000AC0000000000000005
-rw------- 1 postgres postgres 7.3K Mar 4 17:47 000000AC.history
-rw------- 1 postgres postgres 16M Mar 4 17:55 000000AD0000000000000005
-rw------- 1 postgres postgres 7.3K Mar 4 17:49 000000AD.history
-rw------- 1 postgres postgres 16M Mar 4 17:56 000000AE0000000000000005
-rw------- 1 postgres postgres 7.4K Mar 4 17:55 000000AE.history
-rw------- 1 postgres postgres 16M Mar 4 17:59 000000AF0000000000000005
-rw------- 1 postgres postgres 7.4K Mar 4 17:56 000000AF.history
-rw------- 1 postgres postgres 16M Mar 4 18:01 000000B00000000000000005
-rw------- 1 postgres postgres 7.5K Mar 4 17:59 000000B0.history
-rw------- 1 postgres postgres 16M Mar 4 18:12 000000B10000000000000005
-rw------- 1 postgres postgres 7.5K Mar 4 18:01 000000B1.history
-rw------- 1 postgres postgres 16M Mar 4 18:38 000000B20000000000000005
-rw------- 1 postgres postgres 7.5K Mar 4 18:12 000000B2.history
-rw------- 1 postgres postgres 16M Mar 4 18:47 000000B30000000000000005
-rw------- 1 postgres postgres 7.6K Mar 4 18:38 000000B3.history
-rw------- 1 postgres postgres 16M Mar 4 18:52 000000B40000000000000005
-rw------- 1 postgres postgres 7.6K Mar 4 18:48 000000B4.history
-rw------- 1 postgres postgres 16M Mar 4 18:58 000000B50000000000000005
-rw------- 1 postgres postgres 7.7K Mar 4 18:53 000000B5.history
-rw------- 1 postgres postgres 16M Mar 4 19:02 000000B60000000000000005
-rw------- 1 postgres postgres 7.7K Mar 4 18:59 000000B6.history
-rw------- 1 postgres postgres 16M Mar 4 19:16 000000B70000000000000005
-rw------- 1 postgres postgres 7.8K Mar 4 19:02 000000B7.history
-rw------- 1 postgres postgres 16M Mar 4 19:26 000000B80000000000000005
-rw------- 1 postgres postgres 7.8K Mar 4 19:16 000000B8.history
-rw------- 1 postgres postgres 16M Mar 4 20:06 000000B90000000000000005
-rw------- 1 postgres postgres 7.8K Mar 4 19:26 000000B9.history
-rw------- 1 postgres postgres 16M Mar 4 20:26 000000BA0000000000000005
-rw------- 1 postgres postgres 7.9K Mar 4 20:06 000000BA.history
-rw------- 1 postgres postgres 16M Mar 5 15:06 000000BB0000000000000005
-rw------- 1 postgres postgres 7.9K Mar 4 20:26 000000BB.history
-rw------- 1 postgres postgres 16M Mar 5 15:36 000000BC0000000000000005
-rw------- 1 postgres postgres 8.0K Mar 5 15:06 000000BC.history
-rw------- 1 postgres postgres 16M Mar 5 16:25 000000BD0000000000000005
-rw------- 1 postgres postgres 8.0K Mar 5 15:36 000000BD.history
-rw------- 1 postgres postgres 16M Mar 5 16:57 000000BE0000000000000005
-rw------- 1 postgres postgres 8.1K Mar 5 16:25 000000BE.history
-rw------- 1 postgres postgres 16M Mar 5 17:25 000000BF0000000000000005
-rw------- 1 postgres postgres 8.1K Mar 5 16:57 000000BF.history
-rw------- 1 postgres postgres 16M Mar 5 19:14 000000C00000000000000005
-rw------- 1 postgres postgres 8.2K Mar 5 17:25 000000C0.history
-rw------- 1 postgres postgres 16M Mar 5 19:41 000000C10000000000000005
-rw------- 1 postgres postgres 8.2K Mar 5 19:14 000000C1.history
-rw------- 1 postgres postgres 16M Mar 7 09:42 000000C20000000000000005
-rw------- 1 postgres postgres 8.2K Mar 5 19:41 000000C2.history
-rw------- 1 postgres postgres 16M Mar 11 13:44 000000C30000000000000005
-rw------- 1 postgres postgres 8.3K Mar 7 09:42 000000C3.history
-rw------- 1 postgres postgres 16M Mar 11 18:54 000000C40000000000000005
-rw------- 1 postgres postgres 8.3K Mar 11 13:44 000000C4.history
-rw------- 1 postgres postgres 16M Mar 11 18:55 000000C50000000000000005
-rw------- 1 postgres postgres 8.4K Mar 11 18:55 000000C5.history
-rw------- 1 postgres postgres 16M Mar 22 19:26 000000C60000000000000005
-rw------- 1 postgres postgres 8.4K Mar 20 08:10 000000C6.history
-rw------- 1 postgres postgres 16M Mar 22 19:29 000000C70000000000000005
-rw------- 1 postgres postgres 8.5K Mar 22 19:26 000000C7.history
-rw------- 1 postgres postgres 16M Mar 22 23:29 000000C80000000000000005
-rw------- 1 postgres postgres 8.5K Mar 22 19:29 000000C8.history
-rw------- 1 postgres postgres 16M Mar 22 23:41 000000C90000000000000005
-rw------- 1 postgres postgres 8.5K Mar 22 23:29 000000C9.history
-rw------- 1 postgres postgres 16M Mar 23 00:46 000000CA0000000000000005
-rw------- 1 postgres postgres 8.6K Mar 22 23:41 000000CA.history
-rw------- 1 postgres postgres 16M Mar 23 02:14 000000CB0000000000000005
-rw------- 1 postgres postgres 8.6K Mar 23 00:46 000000CB.history
-rw------- 1 postgres postgres 16M Mar 23 02:52 000000CC0000000000000005
-rw------- 1 postgres postgres 8.7K Mar 23 02:14 000000CC.history
-rw------- 1 postgres postgres 16M Mar 23 10:24 000000CD0000000000000005
-rw------- 1 postgres postgres 8.7K Mar 23 02:52 000000CD.history
-rw------- 1 postgres postgres 16M Mar 23 11:15 000000CE0000000000000005
-rw------- 1 postgres postgres 8.8K Mar 23 10:24 000000CE.history
-rw------- 1 postgres postgres 16M Mar 23 13:06 000000CF0000000000000005
-rw------- 1 postgres postgres 8.8K Mar 23 11:15 000000CF.history
-rw------- 1 postgres postgres 16M Mar 23 13:16 000000D00000000000000005
-rw------- 1 postgres postgres 8.8K Mar 23 13:06 000000D0.history
-rw------- 1 postgres postgres 16M Mar 23 15:23 000000D10000000000000005
-rw------- 1 postgres postgres 8.9K Mar 23 13:16 000000D1.history
-rw------- 1 postgres postgres 16M Mar 23 21:33 000000D20000000000000005
-rw------- 1 postgres postgres 8.9K Mar 23 15:23 000000D2.history
-rw------- 1 postgres postgres 16M Mar 23 21:43 000000D30000000000000005
-rw------- 1 postgres postgres 9.0K Mar 23 21:33 000000D3.history
-rw------- 1 postgres postgres 16M Mar 24 03:06 000000D40000000000000005
-rw------- 1 postgres postgres 9.0K Mar 23 21:43 000000D4.history
-rw------- 1 postgres postgres 16M Mar 24 03:16 000000D50000000000000005
-rw------- 1 postgres postgres 9.1K Mar 24 03:06 000000D5.history
-rw------- 1 postgres postgres 16M Mar 24 04:25 000000D60000000000000005
-rw------- 1 postgres postgres 9.1K Mar 24 03:16 000000D6.history
-rw------- 1 postgres postgres 16M Mar 24 04:34 000000D70000000000000005
-rw------- 1 postgres postgres 9.1K Mar 24 04:25 000000D7.history
-rw------- 1 postgres postgres 16M Mar 24 08:24 000000D80000000000000005
-rw------- 1 postgres postgres 9.2K Mar 24 04:34 000000D8.history
-rw------- 1 postgres postgres 16M Mar 24 08:59 000000D90000000000000005
-rw------- 1 postgres postgres 9.2K Mar 24 08:24 000000D9.history
-rw------- 1 postgres postgres 16M Mar 24 09:09 000000DA0000000000000005
-rw------- 1 postgres postgres 9.3K Mar 24 08:59 000000DA.history
-rw------- 1 postgres postgres 16M Mar 24 11:06 000000DB0000000000000005
-rw------- 1 postgres postgres 9.3K Mar 24 09:09 000000DB.history
-rw------- 1 postgres postgres 16M Mar 24 11:14 000000DC0000000000000005
-rw------- 1 postgres postgres 9.4K Mar 24 11:06 000000DC.history
-rw------- 1 postgres postgres 16M Mar 24 15:33 000000DD0000000000000005
-rw------- 1 postgres postgres 9.4K Mar 24 11:14 000000DD.history
-rw------- 1 postgres postgres 16M Mar 24 16:33 000000DE0000000000000005
-rw------- 1 postgres postgres 9.4K Mar 24 15:33 000000DE.history
-rw------- 1 postgres postgres 16M Mar 24 19:37 000000DF0000000000000005
-rw------- 1 postgres postgres 9.5K Mar 24 16:33 000000DF.history
-rw------- 1 postgres postgres 16M Mar 24 19:54 000000E00000000000000005
-rw------- 1 postgres postgres 9.5K Mar 24 19:37 000000E0.history
-rw------- 1 postgres postgres 16M Mar 24 22:02 000000E10000000000000005
-rw------- 1 postgres postgres 9.6K Mar 24 19:54 000000E1.history
-rw------- 1 postgres postgres 16M Mar 25 06:31 000000E20000000000000005
-rw------- 1 postgres postgres 9.6K Mar 24 22:02 000000E2.history
-rw------- 1 postgres postgres 16M Mar 25 07:08 000000E30000000000000005
-rw------- 1 postgres postgres 9.7K Mar 25 06:31 000000E3.history
-rw------- 1 postgres postgres 16M Mar 25 08:44 000000E40000000000000005
-rw------- 1 postgres postgres 9.7K Mar 25 07:08 000000E4.history
-rw------- 1 postgres postgres 16M Mar 25 09:13 000000E50000000000000005
-rw------- 1 postgres postgres 9.7K Mar 25 08:44 000000E5.history
-rw------- 1 postgres postgres 16M Mar 25 09:29 000000E60000000000000005
-rw------- 1 postgres postgres 9.8K Mar 25 09:13 000000E6.history
-rw------- 1 postgres postgres 16M Mar 25 09:54 000000E70000000000000005
-rw------- 1 postgres postgres 9.8K Mar 25 09:29 000000E7.history
-rw------- 1 postgres postgres 16M Mar 25 10:37 000000E80000000000000005
-rw------- 1 postgres postgres 9.9K Mar 25 09:54 000000E8.history
-rw------- 1 postgres postgres 16M Mar 25 13:43 000000E90000000000000005
-rw------- 1 postgres postgres 9.9K Mar 25 10:37 000000E9.history
-rw------- 1 postgres postgres 16M Mar 25 13:52 000000EA0000000000000005
-rw------- 1 postgres postgres 10K Mar 25 13:43 000000EA.history
-rw------- 1 postgres postgres 16M Mar 25 14:15 000000EB0000000000000005
-rw------- 1 postgres postgres 10K Mar 25 13:52 000000EB.history
-rw------- 1 postgres postgres 16M Mar 25 14:29 000000EC0000000000000005
-rw------- 1 postgres postgres 10K Mar 25 14:15 000000EC.history
-rw------- 1 postgres postgres 16M Mar 25 15:03 000000ED0000000000000005
-rw------- 1 postgres postgres 11K Mar 25 14:29 000000ED.history
-rw------- 1 postgres postgres 16M Mar 25 16:42 000000EE0000000000000005
-rw------- 1 postgres postgres 11K Mar 25 15:03 000000EE.history
-rw------- 1 postgres postgres 16M Mar 25 18:34 000000EF0000000000000005
-rw------- 1 postgres postgres 11K Mar 25 16:42 000000EF.history
-rw------- 1 postgres postgres 16M Mar 25 19:23 000000F00000000000000005
-rw------- 1 postgres postgres 11K Mar 25 18:34 000000F0.history
-rw------- 1 postgres postgres 16M Mar 25 22:20 000000F10000000000000005
-rw------- 1 postgres postgres 11K Mar 25 19:23 000000F1.history
-rw------- 1 postgres postgres 16M Mar 26 09:32 000000F20000000000000005
-rw------- 1 postgres postgres 11K Mar 26 01:22 000000F2.history
-rw------- 1 postgres postgres 16M Mar 26 09:33 000000F30000000000000005
-rw------- 1 postgres postgres 16M Mar 26 09:33 000000F30000000000000006
-rw------- 1 postgres postgres 16M Mar 26 09:33 000000F30000000000000007
-rw------- 1 postgres postgres 16M Mar 26 09:33 000000F30000000000000008
-rw------- 1 postgres postgres 16M Mar 26 09:38 000000F30000000000000009
-rw------- 1 postgres postgres 11K Mar 26 09:32 000000F3.history
drwx------ 2 postgres postgres 12K Mar 26 10:56 archive_status
db-pg-0:/var/lib/postgresql/data/pgdata #

BRs,
Fan Liu

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2020-03-26 12:41:34 Re: pg_stat_statements: rows not updated for CREATE TABLE AS SELECT statements
Previous Message Richard Guo 2020-03-26 10:06:45 Re: Negative cost is seen for plan node