Query TpServer Data

SynxDB Cloud provides two methods to access TpServer data, suitable for different business scenarios.

Method 1: Access via Coordinator (Recommended)

This is the standard access method. Applications connect to the Coordinator node and query or manipulate data on TpServer (ROT tables) just like accessing regular tables.

Use cases: All standard SQL operations, including complex JOIN queries, aggregation analysis, and DDL operations.

Method 2: Direct Client Access

In specific scenarios, clients can directly connect to the TpServer process port for operations. Especially for large batch data import scenarios, direct connection mode is recommended to reduce the load on the coordinator node.

Connection method: psql dbname -p [tpserver_port].

Operation restrictions: In direct connection mode, the system enforces strict limitations, allowing only query (SELECT) and write (INSERT) operations. Update (UPDATE) and delete (DELETE) operations must be executed through the Coordinator node. This ensures data consistency and optimizes streaming write performance.