Does Pervasive PSQL take advantage of multiple processors?

Pervasive PSQL fully supports symmetric multiprocessing (SMP) and multiple processors because it is multi-threaded and thread safe. However, Pervasive PSQL does not take direct advantage of any call specific for SMP and is not multiprocessor aware.

In an SMP environment, the operating system schedules available threads on the available processors, including threads for Pervasive PSQL. Since Pervasive PSQL is multi-threaded and thread safe, SMP can yield a performance boost for up to four CPUs. No significant advantage has been shown, however, to bypass the operating system scheduling and use SMP-specific calls to become SMP aware. This is because, in most cases, slowness occurs from disk I/O and not from CPU use.



с 8 и выше

Хотя структуры файлов физически и изменились, но старые версии поддерживаются, есть и конверторы из старых в новое.
Последний PSQL9.5 - самый навороченный, с полноценным SQL и др. прибамбасами.

Тут все есть www.pervasive.com