开发者

Postgres is not taking System Resources

I am restoring my database to my new database in postgresql in linux 2.6.18 kernel. My problem is restoring does not happen quickly, And even system has 90 % free resources. It does not consume all the resource not doing the things as fastest. 开发者_如何学运维what can be issue ? How can overcome this issue.. Please help me out of this problem.

Note : I have used following things for pg_dump and restoring.

pg_dump -Fc -h 192.168.12.165 -d mydb -U mydb -f  log.sql.tar.gz
pg_restore -Fc -h 192.168.12.165 -d mydb -U mydb log.sql.tar.gz

Why this system is not allowing postgres to consume all available memory and cpu resources ?


Postgres uses only very little system resources out of the box, so you will have to adjust the configuration settings to allow it to consume more.

There is a page on the wiki that gives you some hints on how to speed up the restoring of the database: http://wiki.postgresql.org/wiki/Bulk_Loading_and_Restores

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜