I have developed one function in my PostgreSQL database. It was taking 12-15 seconds to execute.
Now I have restored a new PostgreSQL 9.0 dump using following command:
pg_restore -hx.x.x.x -p5432 -d xxx -Ux -Fc -v </path/pgbackup.backup
but on this newly restored database it takes 2 minutes to execute same function.
Please give me possible way to sort out this problem.