|
21 | 21 | <para> |
22 | 22 | A dump/restore is not required for those running 15.X. |
23 | 23 | </para> |
| 24 | + |
| 25 | + <para> |
| 26 | + However, if you regularly create and drop tables exceeding 1GB, |
| 27 | + see the first changelog entry below. |
| 28 | + </para> |
24 | 29 | </sect2> |
25 | 30 |
|
26 | 31 | <sect2> |
|
31 | 36 | <listitem> |
32 | 37 | <!-- |
33 | 38 | Author: Tom Lane <tgl@sss.pgh.pa.us> |
| 39 | +Branch: master [0e758ae89] 2022-11-07 11:36:45 -0500 |
| 40 | +Branch: REL_15_STABLE [5fe0ab420] 2022-11-07 11:36:45 -0500 |
| 41 | +--> |
| 42 | + <para> |
| 43 | + Fix failure to remove non-first segments of large tables |
| 44 | + (Tom Lane) |
| 45 | + </para> |
| 46 | + |
| 47 | + <para> |
| 48 | + <productname>PostgreSQL</productname> splits large tables into |
| 49 | + multiple files (normally with 1GB per file). The logic for dropping |
| 50 | + a table was broken and would miss removing all but the first such |
| 51 | + file, in two cases: drops of temporary tables and WAL replay of |
| 52 | + drops of regular tables. Applications that routinely create |
| 53 | + multi-gigabyte temporary tables could suffer significant disk space |
| 54 | + leakage. |
| 55 | + </para> |
| 56 | + |
| 57 | + <para> |
| 58 | + Orphaned temporary-table files are removed during postmaster start, |
| 59 | + so the mere act of updating to 15.1 is sufficient to clear any |
| 60 | + leaked temporary-table storage. However, if you suffered any |
| 61 | + database crashes while using 15.0, and there might have been |
| 62 | + large tables dropped just before such crashes, it's advisable |
| 63 | + to check the database directories for files named according to the |
| 64 | + pattern |
| 65 | + <literal><replaceable>NNNN</replaceable>.<replaceable>NN</replaceable></literal>. |
| 66 | + If there is no matching file named |
| 67 | + just <literal><replaceable>NNNN</replaceable></literal> (without |
| 68 | + the <literal>.<replaceable>NN</replaceable></literal> suffix), these |
| 69 | + files should be removed manually. |
| 70 | + </para> |
| 71 | + </listitem> |
| 72 | + |
| 73 | + <listitem> |
| 74 | +<!-- |
| 75 | +Author: Tom Lane <tgl@sss.pgh.pa.us> |
34 | 76 | Branch: master [b8f2687fd] 2022-10-11 18:24:14 -0400 |
35 | 77 | Branch: REL_15_STABLE [07ce67698] 2022-10-11 18:24:14 -0400 |
36 | 78 | Branch: REL_14_STABLE [3162bd95c] 2022-10-11 18:24:14 -0400 |
|