twoflower <standa.ku...@gmail.com> 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