On Mon, Mar 24, 2014 at 7:45 AM, Álvaro Nunes Lemos Melo <al_nunes@xxxxxxxxxxx> wrote:
==> Venkata
> After the migration to hardware and to the new version 9.3, any changes have been done in the postgresql.conf compared to the old settings ?No, as I wrote initially, I'd double checked and the four conf files have the same parameters.
ANALYZE yes. VACUUM or VACUUM FULL no, because I ran the test on recently restores and unchanged databases.
> Any maintenance activities (VACUUM or VACUUM FULL and ANALYZE) have been performed after the migration ?
How did you do the restore? Please VACUUM and retest. At best it will fix the problem, and if it doesn't it will at least rule out a bunch of possibilities for the source of the problem.
Cheers,
Jeff
