|
Getting started with PostgreSQL requires registration, installation, and configuration. Most of this process is performed independently of ThingWorx, and is documented in Installing ThingWorx.
|
|
The standard PostgreSQL implementation includes a persistence provider, which cannot be edited within ThingWorx. However, you can edit it via the platform-settings.json or services.
|
Stream Processor Settings
|
Base Type
|
Default
|
Notes
|
---|---|---|---|
Max Queue Size
|
Number
|
250000
|
Maximum number of stream entries to queue.Once the specified value is reached, the following entries will be rejected.
|
Max Wait Time Before Flushing Stream Buffer (millisec)
|
Number
|
2000
|
Number of milliseconds the system waits before flushing the stream buffer
|
Number of Processing Threads
|
Number
|
5
|
Number of processing threads allocated to the stream
|
Max no. of Items Before Flushing Stream Buffer
|
Number
|
500
|
Maximum number of items to accumulate before flushing the stream buffer
|
Max no. of Stream Writes in Process Block
|
Number
|
2500
|
Maximum number of stream writes to process in one block
|
Buffer Status Scan Rate (millisec)
|
Number
|
5
|
The buffer status is checked at the specified rate value in milliseconds.
|
Value Stream Processor Settings
|
Base Type
|
Default
|
Notes
|
---|---|---|---|
Max Queue Size
|
Number
|
250000
|
Maximum number of value stream entries to queue. Once the specified value is reached, the following entries will be rejected.
|
Max Wait Time Before Flushing Value Stream Buffer (millisec)
|
Number
|
2000
|
Number of milliseconds the system waits before flushing the value stream buffer
|
Number of Processing Threads
|
Number
|
5
|
Number of processing threads allocated to the value stream
|
Max no. of Items Before Flushing Value Buffer
|
Number
|
500
|
Maximum number of items to accumulate before flushing the value stream buffer
|
Max no. of Value Stream Writes in Process Block
|
Number
|
2500
|
Maximum number of value stream writes to process in one block
|
Buffer Status Scan Rate (millisec)
|
Number
|
5
|
The buffer status is checked at the specified rate value in milliseconds.
|
Name
|
Default Value
|
Notes
|
---|---|---|
JDBC URL
|
jdbc:postgresql://localhost:5432/thingworx
|
The JDBC URL of the database from which connections should be acquired. You can specify multiple schemas in this URL.
|
Username
|
thingworx
|
User name used to acquire a database connection
|
Password
|
n/a
|
Password used to acquire a database connection
|
Initial Connection Pool Size
|
5
|
Number of connections a pool will try to acquire upon startup
|
Connection Acquire Increment
|
5
|
Determines how many connections will be acquired when the pool is exhausted
|
Max Connection Pool Size
|
100
|
Maximum number of connections a pool maintains at any given time
|
Min Connection Pool Size
|
5
|
Minimum number of connections a pool maintains at any given time
|
Max Cached Statements
|
100
|
Size of global PreparedStatement cache
|
Driver Class
|
org.postgresql.Driver
|
Database JDBC driver class
|
Acquire Retry Attempts
|
3
|
Defines how many times the connection pool will try to acquire a new connection
|
Acquire Retry Delay
|
10000
|
Time in milliseconds in which the connection pool will wait between acquire attempts
|
Checkout Retry Timeout
|
1000000
|
Number of milliseconds a client calling getConnection will wait for a connection to be checked in or acquired when the pool is exhausted
|
Max Idle Time
|
0
|
Seconds a connection can remain pooled but unused before being discarded. Zero means idle connections never expire.
|
Max Connection Age
|
0
|
Connections older than this time, in seconds, will be destroyed and purged from the pool. Zero means no maximum age is enforced.
|
Number of Helper Threads
|
8
|
Slow JDBC operations are generally performed by helper threads that do not hold contended locks. Spreading these operations over multiple threads can significantly improve performance by allowing multiple operations to be performed simultaneously.
|
Unreturned Connection Timeout
|
0
|
If the application acquires a connection but failed to close it within the specified period of time, in seconds, the pool will destroy the connection. Zero means no timeout, and the applications are expected to close their own connections.
|
Max Idle Time for Excess Connections
|
300
|
Number of seconds that connections in excess of minPoolSize should be permitted to remain idle in the pool before being destroyed. Zero means no enforcement and excess connections are not destroyed.
|