twoflower <standa.kurik@xxxxxxxxx> writes: > One issue I cannot resolve is the new server using a parallel seq scan > instead of index-only scan for the following query: > select count(id) from history_translation You might need to vacuum the table to ensure that the planner thinks a reasonable proportion of the pages are all-visible (see pg_class.relallvisible). regards, tom lane