How can I utilize more of the RAM and CPU of my machine?

[tdwrobinson]

Working on a data migration. Largest table is around 800,000 records.

Using an i7, Quad Core Windows 7 (64bit) machine with 8Gb RAM.

It's a new clean system with really only Servoy and Adobe Reader installed.

When running the migration, the CPU is only utilized at 12% and only 1.8Gb of RAM is being used.

Is there a way to utilize more of the RAM & CPU so that the migration can move along more quickly?

I've tweaked several preferences in postgresql.conf including increasing shared_buffers to 1024 is the only thing that has made a small difference.

[Jan Blok]

For Servoy server check memory section here

[jcompagner]

problem with this is that it could be that I/O is the bottleneck not the CPU power or memory
But does the migration really run multi threaded? Because if it is just a single tread that copies/migrates the tables then only 1 core of your quad core system will be used
And i guess this is what happens. Your quad core cpu has in total 8 logical cores (because of hyper threading) that means that 1 core fully used is 100%/8 = 12.5% ... exactly the number you see...