Re: don't create storage when unnecessary
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-12-06T22:51:15Z
Lists: pgsql-hackers
Hi, On 2018-12-06 18:55:52 -0300, Alvaro Herrera wrote: > Some time ago, after partitioned indexes had been pushed, I realized > that even though I didn't want them to have relfilenodes, they did. And > looking closer I noticed that *a lot* of relation kinds that didn't need > relfilenodes, had them anyway. > > This patch fixes that; if no relfilenode is needed, it's not created. > > I didn't verify pg_upgrade behavior across this commit. Maybe something > needs tweaking there. Hm, that generally sounds like a good plan. Could we back this up with tests in misc_sanity.sql or such? - Andres
Commits
-
Don't create relfilenode for relations without storage
- 807ae415c546 12.0 landed
-
Rename macro to RELKIND_HAS_STORAGE
- df5be63763f8 12.0 landed