SynxDB Logo

Table of Contents

  • Product Overview
    • Feature Overview
    • Product Architecture
    • User Scenarios
    • Comparison with Greenplum
    • Release Notes
      • v4.8.0 Release Notes
      • v4.7.0 Release Notes
      • v4.6.0 Release Notes
      • v4.5.0 Release Notes
      • v4.4.0 Release Notes
      • v4.3.0 Release Notes
      • v4.2.0 Release Notes
      • v4.1.0 Release Notes
      • v4.0.0 Release Notes
    • TPC-DS Benchmark Report
    • Release Roadmap
  • Deploy Clusters
    • Software and Hardware Requirements
    • Prepare the Environment
    • Deploy on Multiple Nodes
    • Deploy on a Single Node
    • Install Extensions
  • Set Up Databases
    • Create and Manage Databases
    • Start and Stop Databases
    • Connect to Databases
  • Load Data
    • From Local Files
      • Use COPY
      • Use gpfdist
      • Use the file Protocol
      • Use gpload
    • From Web Services
    • From Kafka
    • From Object Storage and HDFS
    • From Hive
    • From MySQL
    • From a Remote Cluster
    • Use Foreign Tables
    • Use PXF
    • Use Iceberg Tables
    • Use Multi-Character Delimiters
    • Use Apache NiFi
  • Work with Data
    • Manage Database Objects
      • Write Basic Queries
      • Create and Manage Tables
      • Partition Large Tables
      • Insert, Update, and Delete Rows
      • Create and Manage Views
      • Create and Manage Materialized Views
      • Create and Manage Indexes
      • Use BRIN Indexes
      • Work with Transactions
      • Control Transaction Concurrency
      • Choose a Table Storage Model
        • Heap and Append-Optimized Table Storage Models
        • PAX Storage Format
        • UnionStore Storage Format
      • Query Across Clusters
      • Tag Database Objects
    • Query with SQL
      • Write Join Queries
    • Advanced Analytics
      • pgvector
      • Vectorized Queries
      • MADlib
      • Directory Tables
      • RoaringBitmap
      • Time-Series Data
    • Auto-Execute SQL Commands
    • Run Oracle-Compatible SQL with Orafce
  • Optimize Performance
    • Query Tuning
      • How Queries Are Processed
      • Automatic Query Optimizations
      • Use GPORCA Optimizer
        • GPORCA Overview
        • GPORCA Features and Enhancements
        • GPORCA Performance Tuning
      • Update Statistics
      • Use Query Plan Hints
      • Execute Queries in Parallel
      • Push Down Aggregation Operations
      • Optimize HashJoin Query Performance
      • Use Index Scan on AO Tables
      • Use Unique Indexes on AO Tables
      • Use Automatic Materialized Views
      • Use Incremental Materialized Views
    • Create Indexes Concurrently
    • Create Tables and Refresh Views in Parallel
    • Limit Workloads with Resource Groups
    • Use Dynamic Tables
  • Machine Learning and AI
    • Deploy the ML Platform
    • Train and Deploy Models
    • Use AIFun
  • Manage System
    • Monitor and Manage with DBCC
      • Understand the Architecture
      • Install DBCC
      • View the Dashboard
      • Manage Clusters
      • Check Cluster Status and Metrics
      • View Database Objects
      • Monitor SQL and Sessions
      • Check Storage Usage
      • Manage Resource Groups
      • Monitor PgBouncer Pools
      • Edit Database Parameters
      • Check Table Bloat and Skew
      • Manage Alert Rules
      • Manage Contact Groups
    • Backup and Restore
      • Overview
      • Full Backup
      • Incremental Backup
      • Continuous Archiving (CBDR)
    • Expand and Shrink a Cluster
    • Upgrade the Cluster
    • Upgrade with gpupgrade
    • Configure Security and Permissions
      • Password Policies
      • Password Strength
      • pgcrypto
      • Anon
      • TDE
      • pgAudit
      • Roles and Privileges
    • Set Server Configuration Parameters
  • Use Extensions
    • ZomboDB
    • pg_partman
    • pg_search
  • Reference
    • SQL Statements
      • ABORT
      • ALTER DATABASE
      • ALTER RULE
      • ALTER TABLE
      • ALTER TABLESPACE
      • ANALYZE
      • BEGIN
      • COMMIT
      • COPY
      • CREATE DATABASE
      • CREATE INDEX
      • CREATE MATERIALIZED VIEW
      • CREATE ROLE
      • CREATE SCHEMA
      • CREATE TABLE
      • CREATE TABLE AS
      • CREATE TABLESPACE
      • CREATE VIEW
      • DELETE
      • DROP DATABASE
      • DROP EXTENSION
      • DROP EXTERNAL TABLE
      • DROP INDEX
      • DROP MATERIALIZED VIEW
      • DROP ROLE
      • DROP RULE
      • DROP SCHEMA
      • DROP TABLE
      • DROP TABLESPACE
      • DROP TYPE
      • DROP USER
      • DROP VIEW
      • END
      • EXPLAIN
      • GRANT
      • INSERT
      • REFRESH MATERIALIZED VIEW
      • REVOKE
      • ROLLBACK
      • ROLLBACK TO SAVEPOINT
      • SAVEPOINT
      • SELECT
      • SET ROLE
      • SET TRANSACTION
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • VACUUM
    • System Utilities
      • Create a Demo Cluster with gpdemo
    • System Catalogs
      • System Views
      • gp_toolkit Administrative Schema
    • Configuration Parameters
  • Tutorials
    • System Configuration Best Practices
    • PAX Table Best Practices
  • Develop Applications
    • Develop Extensions with PGRX
    • Procedural Languages
      • Use PL/Container
    • Use the MCP Service
SynxDB
  • Search

© 2026, Synx Data Labs. All rights reserved.

SynxDB