Perumal Raj <perucinci@xxxxxxxxx> writes: > I have used pg_upgrade which runs "analyze_new_cluster.sh" as post upgrade > activity across all DB on cluster. pg_upgrade itself won't run that script, it only creates it for you to run. > Also, I have executed manual vacuum on all individual tables. However the > behavior is same until i disable the above said parameter. Did those manual vacuums include an "analyze" option? If you in fact haven't got analyze results on your tables, that might explain your problems. autovacuum would eventually rectify the situation for larger tables, but it might never get around to small seldom-updated tables. If that's not it, I again direct your attention to the Slow_Query_Questions wiki page. That summarizes a lot of past experience with solving performance problems, and you're not endearing yourself to potential helpers by refusing to follow the process. regards, tom lane
