On 2023-01-14 11:34:13 +0530, jian he wrote: > Once we have the diff table, we perform set-based DELETE and INSERT > operations against the materialized view, and discard both temporary > tables. > > > Here the temporary tables are "discard" meaning the temporary tables are > deleted and the temporary tables' spaces are reclaimed immediately? > Or the temporary tables are deleted and the spaces will be reclaimed by another > mechanism? Tables are implemented as files by PostgreSQL. When a table is dropped, the file is deleted[1]. Whether that means that the space is "immediately" available again is up to the operating system. hp [1] Possibly delayed until commit. -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature