Configuration Settings
Pervasive PSQL v11 includes changes to the following configuration settings:
•
Communications Threads
•
Listen IP Address
Communications Threads
The range and default for the Communications Threads setting have changed.
•
The range is now num_cores to 256, where num_cores is the number of processors in the machine on which the database engine is running.
•
The default is num_cores.
Previously, the range was 1 to 1,024 and the default was 16.
The Communications Threads setting can help improve scaling under certain conditions. For example, if you have many clients performing operations (typically writes) on one file, a lower setting should improve scalability. The lower number of threads prevents context switching on system resources. Another condition that this setting may improve is a slowdown caused by thrashing among large numbers of worker threads. In Pervasive PSQL v11, worker threads are dynamically created only if all the existing threads are waiting on record or file locks.
See Communications Threads in Advanced Operations Guide.
Listen IP Address
The Listen IP Address setting now accepts multiple IP addresses separated by a comma between each address. The string can be a combination of IPv4 and IPv6 addresses. Any of the IPv6 address formats supported can be used. See IPv6 Address Formats.
The Listen IP Address setting specifies the IP address or addresses the database engine listens on when TCP/IP Multihomed is Off. See also Listen IP Address and TCP/IP Multihomed in Advanced Operations Guide.