Vacuum everything that you restored
Sent from my iPhone
> On Feb 26, 2020, at 1:19 PM, Michael Lewis <mlewis(at)entrata(dot)com> wrote:
>
>
>> UPDATE multicards
>> SET defacements = COALESCE( count, 0 )
>> FROM ( SELECT multicard_uid, COUNT(*) AS count FROM tickets GROUP BY multicard_uid ) AS sub
>> WHERE uid = multicard_uid OR multicard_uid is null;
>
> I expect this should work. Not sure of performance of course.