GC improvements: GC only on a single node and add a missing index in PG

GC improvements: GC only on a single node and add a missing index in PG #6323