Re: Optimizing PT performance for BIG databases...remote database?
With your proposed setup I would do the following: (I've been thinking about doing this for awhile now)
1. Move your Postgres databases to your server.
2. Increase Postgres' memory usages to about 75% of your server's memory.
2. Install PT on both server & main computer
3. Use PT on server for import; PT on main computer only for viewing stats
This would alleviate PT's and Postgres' CPU load on your main computer. On my machine, I'm looking at ~50-60% CPU usage at times.
You may notice a slight speed-up of imports with this situation. Probably nothing very notable if at all. The key IMHO is the reduced CPU load on your main computer...
|