Revert "Merge branch 'revert_62665' into '23.0'"

This reverts merge request !62729 (merged)

This is the revert of the "revert" for using memory pools for a map

ping @jchapman as we discussed that this should prb go back in