SynxDB
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
Index
Index