| import type { SidebarsConfig } from "@docusaurus/plugin-content-docs"; |
| |
| /** |
| * Creating a sidebar enables you to: |
| - create an ordered group of docs |
| - render a sidebar for each doc of that group |
| - provide next/previous navigation |
| |
| The sidebars can be generated from the filesystem, or explicitly defined here. |
| |
| Create as many sidebars as you want. |
| */ |
| const sidebars: SidebarsConfig = { |
| docsbars: [ |
| |
| { |
| type: 'category', |
| label: 'Introduction', |
| items: ['cbdb-overview', 'cbdb-architecture', 'cbdb-scenarios', 'cbdb-vs-gp-features'] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Deploy and Build', |
| items: [ |
| 'deployment/build-based-on-docker', |
| { |
| type: 'category', |
| label: 'Build from Source (Complete Guide)', |
| link: { |
| type: "doc", |
| id: 'deployment/index', |
| }, |
| items: [`deployment/quick-build`, `deployment/create-gpadmin-user`, `deployment/system-settings`, `deployment/install-required-packages`, `deployment/download-source-code`, `deployment/configure`, `deployment/build-and-install`, `deployment/set-demo-cluster`, `deployment/post-installation`] |
| }, |
| { |
| type: 'category', |
| label: 'Deploy on Physical or Virtual Machine', |
| items: ['cbdb-op-software-hardware', 'cbdb-op-prepare-to-deploy', 'cbdb-op-deploy-guide', 'deploy-cbdb-with-single-node'] |
| }, |
| 'deployment/sandbox' |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Load Data', |
| link: { |
| type: "doc", |
| id: 'data-loading/index', |
| }, |
| items: [ |
| { |
| type: 'category', |
| label: 'From Local or Network Files', |
| items: [ |
| 'data-loading/load-data-using-copy', |
| 'data-loading/load-data-using-gpfdist', |
| 'data-loading/load-data-using-gpfdists', |
| 'data-loading/load-data-using-file-protocol', |
| 'data-loading/load-data-using-gpload', |
| ], |
| }, |
| { |
| type: 'category', |
| label: 'From Cloud or Big Data Systems', |
| items: [ |
| 'data-loading/load-data-from-s3', |
| 'data-loading/load-data-using-pxf', |
| ], |
| }, |
| 'data-loading/load-data-from-web-services', |
| 'data-loading/load-data-from-kafka-using-fdw', |
| 'data-loading/handle-data-errors', |
| ], |
| }, |
| |
| { |
| type: 'category', |
| label: 'Create and Prepare', |
| items: ['operate-with-data/operate-with-db-objects/create-and-manage-database', 'start-and-stop-cbdb-database', 'connect-to-cbdb'] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Operate with Data', |
| items: [ |
| { |
| type: 'category', |
| label: 'Operate with Database Objects', |
| items: ['operate-with-data/operate-with-db-objects/create-and-manage-tablespaces', 'operate-with-data/operate-with-db-objects/create-and-manage-tables', 'operate-with-data/operate-with-db-objects/table-definition-basics', 'operate-with-data/operate-with-db-objects/create-and-manage-schemas', 'operate-with-data/operate-with-db-objects/create-and-manage-views', 'operate-with-data/operate-with-db-objects/view-storage', 'operate-with-data/operate-with-db-objects/work-with-view-dependencies', 'operate-with-data/operate-with-db-objects/create-and-manage-materialized-views', 'operate-with-data/operate-with-db-objects/create-and-manage-indexes', 'operate-with-data/operate-with-db-objects/brin-indexes', 'operate-with-data/operate-with-db-objects/create-and-manage-partitioned-tables', 'operate-with-data/operate-with-db-objects/about-table-partitioning', 'operate-with-data/operate-with-db-objects/create-and-manage-sequences', 'operate-with-data/operate-with-db-objects/insert-update-delete-rows'] |
| }, |
| { |
| type: 'category', |
| label: 'SQL Queries', |
| link: { |
| type: "doc", |
| id: 'operate-with-data/sql-queries/index', |
| }, |
| items: ['operate-with-data/sql-queries/basic-query-syntax', 'operate-with-data/sql-queries/sql-language', 'operate-with-data/sql-queries/where-clauses', 'operate-with-data/sql-queries/group-by-and-having-clauses', 'operate-with-data/sql-queries/join-queries', 'operate-with-data/sql-queries/table-and-column-aliases', 'operate-with-data/sql-queries/evaluation-order', 'operate-with-data/sql-queries/value-expressions', 'operate-with-data/sql-queries/aggregates-expressions', 'operate-with-data/sql-queries/subqueries', 'operate-with-data/sql-queries/cte-queries', 'operate-with-data/sql-queries/table-functions', 'operate-with-data/sql-queries/window-functions', |
| |
| { |
| type: 'category', |
| label: 'Full Text Search', |
| link: { |
| type: "doc", |
| id: 'operate-with-data/sql-queries/full-text-search/index', |
| }, |
| items: [ |
| 'operate-with-data/sql-queries/full-text-search/full-text-search-intro', |
| 'operate-with-data/sql-queries/full-text-search/search-text-in-db', |
| 'operate-with-data/sql-queries/full-text-search/control-text-search', |
| 'operate-with-data/sql-queries/full-text-search/additional-text-search-features', |
| 'operate-with-data/sql-queries/full-text-search/text-search-parsers', |
| 'operate-with-data/sql-queries/full-text-search/text-search-dictionaries', |
| 'operate-with-data/sql-queries/full-text-search/text-search-configuration', |
| 'operate-with-data/sql-queries/full-text-search/test-and-debug-text-search', |
| 'operate-with-data/sql-queries/full-text-search/preferred-indexes-for-full-text-search', |
| 'operate-with-data/sql-queries/full-text-search/text-search-psql-support', |
| 'operate-with-data/sql-queries/full-text-search/full-text-search-limitations', |
| ] |
| } |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Advanced Analytics', |
| items: ['advanced-analytics/postgis', 'advanced-analytics/directory-tables', 'advanced-analytics/pgvector-search'] |
| }, |
| 'operate-with-data/heap-and-ao-table-formats', 'operate-with-data/pax-table-format', 'operate-with-data/work-with-transactions', 'operate-with-data/transactional-concurrency-control', 'operate-with-data/manage-spill-files' |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Optimize Performance', |
| items: ['performance/define-database-performance', |
| { |
| type: 'category', |
| label: 'Optimize Query Performance', |
| link: { |
| type: "doc", |
| id: 'performance/optimize-queries/index' |
| }, |
| items: [ |
| 'performance/optimize-queries/query-process-overview', 'performance/optimize-queries/analyze-query-performance', |
| { |
| type: 'category', |
| label: 'GPORCA Query Optimizer', |
| items: ['performance/optimize-queries/use-orca/use-orca-overview', 'performance/optimize-queries/use-orca/orca-features', 'performance/optimize-queries/use-orca/whats-new-in-orca', 'performance/optimize-queries/use-orca/gporca-collect-root-partition-stats', 'performance/optimize-queries/use-orca/gporca-limitations', 'performance/optimize-queries/use-orca/gporca-usage-considerations'] |
| }, |
| 'performance/optimize-queries/use-unique-index-on-ao-tables', 'performance/optimize-queries/use-auto-materialized-view-to-answer-queries', 'performance/optimize-queries/use-incremental-materialized-view', 'performance/optimize-queries/parallel-create-ao-refresh-mv', 'performance/optimize-queries/parallel-query-execution', 'performance/optimize-queries/use-aggre-pushdown-to-speed-up-queries', 'performance/optimize-queries/use-index-scan-on-ao-tables', 'performance/optimize-queries/use-runtimefilter-to-optimize-queries', 'performance/optimize-queries/query-hints'] |
| }, |
| 'performance/distribution-and-skew', 'performance/memory-overview', 'performance/update-stats-using-analyze', 'performance/use-columnar-compression', |
| { |
| type: 'category', |
| label: 'Manage Resources', |
| link: { |
| type: "doc", |
| id: 'performance/manage-resources', |
| }, |
| items: ['performance/manage-resources-using-resource-queues', 'performance/manage-resources-using-resource-groups'] |
| }, |
| 'performance/use-dynamic-tables', 'performance/common-cause-of-performance-issues', 'performance/investigate-performance-issues'] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Security and Permission', |
| link: { |
| type: "doc", |
| id: 'security/index', |
| }, |
| items: [ |
| 'security/ports-and-protocols', |
| 'security/manage-roles-and-privileges', |
| 'security/client-auth', |
| 'security/configure-db-auth', |
| 'security/encrypt-data-and-db-connections', |
| 'security/transparent-data-encryption', |
| 'security/log-auditing', |
| 'security/configure-row-level-security-policy', |
| 'security/protect-passwords', |
| 'security/set-password-profile', |
| 'security/security-best-practices' |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Manage System', |
| items: [ |
| 'sys-admin/configure-database-system', |
| 'sys-admin/configure-proxy', |
| 'sys-admin/check-database-system', |
| { |
| type: 'category', |
| label: 'Backup and Restore', |
| link: { |
| type: "doc", |
| id: 'sys-admin/backup-and-restore/index', |
| }, |
| items: [ |
| 'sys-admin/backup-and-restore/perform-full-backup-and-restore', |
| 'sys-admin/backup-and-restore/perform-incremental-backup-and-restore' |
| ] |
| }, |
| { |
| type: 'category', |
| label: 'High Availability', |
| link: { |
| type: "doc", |
| id: 'sys-admin/high-availability/high-availability-overview', |
| }, |
| items: [ |
| 'sys-admin/high-availability/segment-mirroring-overview', |
| 'sys-admin/high-availability/coordinator-mirroring-overview', |
| { |
| type: 'category', |
| label: 'Enable Mirroring', |
| link: { |
| type: "doc", |
| id: 'sys-admin/high-availability/enable-mirroring' |
| }, |
| items: [ |
| 'sys-admin/high-availability/enable-segment-mirroring', |
| 'sys-admin/high-availability/enable-coordinator-mirroring' |
| ] |
| }, |
| 'sys-admin/high-availability/detect-a-failed-segment', |
| 'sys-admin/high-availability/understand-segment-recovery', |
| 'sys-admin/high-availability/check-for-failed-segments', |
| 'sys-admin/high-availability/recover-from-segment-failures', |
| 'sys-admin/high-availability/recover-a-failed-coordinator', |
| 'sys-admin/high-availability/restore-coordinator-mirroring-after-a-recovery' |
| ] |
| }, |
| { |
| type: 'category', |
| label: 'Expand Cluster', |
| link: { |
| type: "doc", |
| id: 'sys-admin/expand-cluster/expand-a-db-system' |
| }, |
| items: [ |
| 'sys-admin/expand-cluster/system-expansion-overview', |
| 'sys-admin/expand-cluster/plan-system-expansion', |
| 'sys-admin/expand-cluster/prepare-and-add-hosts', |
| 'sys-admin/expand-cluster/initialize-new-segments', |
| 'sys-admin/expand-cluster/redistribute-tables', |
| 'sys-admin/expand-cluster/post-expansion-tasks' |
| ] |
| }, |
| 'sys-admin/use-compression', |
| 'sys-admin/migration-and-upgrade', |
| 'sys-admin/recommended-maintenance-monitoring-tasks', |
| 'sys-admin/routine-maintain-tasks', |
| 'sys-admin/monitor-long-running-operations' |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Developer', |
| items: [ |
| 'developer/develop-background-process-worker', |
| 'developer/develop-extensions-using-rust', |
| 'developer/supported-bi-tools', |
| 'developer/use-jdbc-driver', |
| 'developer/use-odbc-driver', |
| |
| { |
| type: 'category', |
| label: 'Stored Procedures and UDFs', |
| items: [ |
| 'developer/functions-and-procedures/overview', |
| 'developer/functions-and-procedures/use-pl-container', |
| 'developer/functions-and-procedures/use-pl-java', |
| 'developer/functions-and-procedures/use-pl-perl', |
| 'developer/functions-and-procedures/use-pl-pgsql', |
| 'developer/functions-and-procedures/use-pl-python', |
| 'developer/functions-and-procedures/use-pl-r' |
| ] |
| }, |
| 'developer/write-a-foreign-data-wrapper' |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Ecosystem', |
| items: [ |
| { |
| type: 'category', |
| label: 'SQL Clients', |
| items: ['ecosystem/sql-clients/dbeaver'] |
| }, |
| { |
| type: 'category', |
| label: 'Data Integration', |
| items: ['ecosystem/data-integration/seatunnel'] |
| } |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'References', |
| items: [ |
| { |
| type: 'category', |
| label: 'SQL Statements', |
| link: { |
| type: "doc", |
| id: 'sql-stmts/index', |
| }, |
| items: [ |
| 'sql-stmts/abort', |
| 'sql-stmts/alter-aggregate', |
| 'sql-stmts/alter-collation', |
| 'sql-stmts/alter-conversion', |
| 'sql-stmts/alter-database', |
| 'sql-stmts/alter-default-privileges', |
| 'sql-stmts/alter-domain', |
| 'sql-stmts/alter-extension', |
| 'sql-stmts/alter-external-table', |
| 'sql-stmts/alter-foreign-data-wrapper', |
| 'sql-stmts/alter-foreign-table', |
| 'sql-stmts/alter-function', |
| 'sql-stmts/alter-group', |
| 'sql-stmts/alter-index', |
| 'sql-stmts/alter-language', |
| 'sql-stmts/alter-materialized-view', |
| 'sql-stmts/alter-operator-class', |
| 'sql-stmts/alter-operator-family', |
| 'sql-stmts/alter-operator', |
| 'sql-stmts/alter-policy', |
| 'sql-stmts/alter-procedure', |
| 'sql-stmts/alter-protocol', |
| 'sql-stmts/alter-resource-group', |
| 'sql-stmts/alter-resource-queue', |
| 'sql-stmts/alter-role', |
| 'sql-stmts/alter-routine', |
| 'sql-stmts/alter-rule', |
| 'sql-stmts/alter-schema', |
| 'sql-stmts/alter-sequence', |
| 'sql-stmts/alter-server', |
| 'sql-stmts/alter-statistics', |
| 'sql-stmts/alter-table', |
| 'sql-stmts/alter-tablespace', |
| 'sql-stmts/alter-text-search-configuration', |
| 'sql-stmts/alter-text-search-dictionary', |
| 'sql-stmts/alter-text-search-parser', |
| 'sql-stmts/alter-text-search-template', |
| 'sql-stmts/alter-trigger', |
| 'sql-stmts/alter-type', |
| 'sql-stmts/alter-user-mapping', |
| 'sql-stmts/alter-user', |
| 'sql-stmts/alter-view', |
| 'sql-stmts/analyze', |
| 'sql-stmts/begin', |
| 'sql-stmts/call', |
| 'sql-stmts/checkpoint', |
| 'sql-stmts/close', |
| 'sql-stmts/cluster', |
| 'sql-stmts/comment', |
| 'sql-stmts/commit', |
| 'sql-stmts/copy', |
| 'sql-stmts/create-access-method', |
| 'sql-stmts/create-aggregate', |
| 'sql-stmts/create-cast', |
| 'sql-stmts/create-collation', |
| 'sql-stmts/create-conversion', |
| 'sql-stmts/create-database', |
| 'sql-stmts/create-domain', |
| 'sql-stmts/create-extension', |
| 'sql-stmts/create-external-table', |
| 'sql-stmts/create-foreign-data-wrapper', |
| 'sql-stmts/create-foreign-table', |
| 'sql-stmts/create-function', |
| 'sql-stmts/create-group', |
| 'sql-stmts/create-index', |
| 'sql-stmts/create-language', |
| 'sql-stmts/create-materialized-view', |
| 'sql-stmts/create-operator-class', |
| 'sql-stmts/create-operator-family', |
| 'sql-stmts/create-operator', |
| 'sql-stmts/create-policy', |
| 'sql-stmts/create-procedure', |
| 'sql-stmts/create-protocol', |
| 'sql-stmts/create-resource-group', |
| 'sql-stmts/create-resource-queue', |
| 'sql-stmts/create-role', |
| 'sql-stmts/create-rule', |
| 'sql-stmts/create-schema', |
| 'sql-stmts/create-sequence', |
| 'sql-stmts/create-server', |
| 'sql-stmts/create-statistics', |
| 'sql-stmts/create-table-as', |
| 'sql-stmts/create-table', |
| 'sql-stmts/create-tablespace', |
| 'sql-stmts/create-text-search-configuration', |
| 'sql-stmts/create-text-search-dictionary', |
| 'sql-stmts/create-text-search-parser', |
| 'sql-stmts/create-text-search-template', |
| 'sql-stmts/create-transform', |
| 'sql-stmts/create-trigger', |
| 'sql-stmts/create-type', |
| 'sql-stmts/create-user-mapping', |
| 'sql-stmts/create-user', |
| 'sql-stmts/create-view', |
| 'sql-stmts/deallocate', |
| 'sql-stmts/declare', |
| 'sql-stmts/delete', |
| 'sql-stmts/discard', |
| 'sql-stmts/do', |
| 'sql-stmts/drop-access-method', |
| 'sql-stmts/drop-aggregate', |
| 'sql-stmts/drop-cast', |
| 'sql-stmts/drop-collation', |
| 'sql-stmts/drop-conversion', |
| 'sql-stmts/drop-database', |
| 'sql-stmts/drop-domain', |
| 'sql-stmts/drop-extension', |
| 'sql-stmts/drop-external-table', |
| 'sql-stmts/drop-foreign-data-wrapper', |
| 'sql-stmts/drop-foreign-table', |
| 'sql-stmts/drop-function', |
| 'sql-stmts/drop-group', |
| 'sql-stmts/drop-index', |
| 'sql-stmts/drop-language', |
| 'sql-stmts/drop-materialized-view', |
| 'sql-stmts/drop-operator-class', |
| 'sql-stmts/drop-operator-family', |
| 'sql-stmts/drop-operator', |
| 'sql-stmts/drop-owned', |
| 'sql-stmts/drop-policy', |
| 'sql-stmts/drop-procedure', |
| 'sql-stmts/drop-protocol', |
| 'sql-stmts/drop-resource-group', |
| 'sql-stmts/drop-resource-queue', |
| 'sql-stmts/drop-role', |
| 'sql-stmts/drop-routine', |
| 'sql-stmts/drop-rule', |
| 'sql-stmts/drop-schema', |
| 'sql-stmts/drop-sequence', |
| 'sql-stmts/drop-server', |
| 'sql-stmts/drop-statistics', |
| 'sql-stmts/drop-table', |
| 'sql-stmts/drop-tablespace', |
| 'sql-stmts/drop-text-search-configuration', |
| 'sql-stmts/drop-text-search-dictionary', |
| 'sql-stmts/drop-text-search-parser', |
| 'sql-stmts/drop-text-search-template', |
| 'sql-stmts/drop-transform', |
| 'sql-stmts/drop-trigger', |
| 'sql-stmts/drop-type', |
| 'sql-stmts/drop-user-mapping', |
| 'sql-stmts/drop-user', |
| 'sql-stmts/drop-view', |
| 'sql-stmts/end', |
| 'sql-stmts/execute', |
| 'sql-stmts/explain', |
| 'sql-stmts/fetch', |
| 'sql-stmts/grant', |
| 'sql-stmts/import-foreign-schema', |
| 'sql-stmts/insert', |
| 'sql-stmts/listen', |
| 'sql-stmts/load', |
| 'sql-stmts/lock', |
| 'sql-stmts/move', |
| 'sql-stmts/notify', |
| 'sql-stmts/prepare', |
| 'sql-stmts/reassign-owned', |
| 'sql-stmts/refresh-materialized-view', |
| 'sql-stmts/reindex', |
| 'sql-stmts/release-savepoint', |
| 'sql-stmts/reset', |
| 'sql-stmts/retrieve', |
| 'sql-stmts/revoke', |
| 'sql-stmts/rollback-to-savepoint', |
| 'sql-stmts/rollback', |
| 'sql-stmts/savepoint', |
| 'sql-stmts/select-into', |
| 'sql-stmts/select', |
| 'sql-stmts/set-constraints', |
| 'sql-stmts/set-role', |
| 'sql-stmts/set-session-authorization', |
| 'sql-stmts/set-transaction', |
| 'sql-stmts/set', |
| 'sql-stmts/show', |
| 'sql-stmts/start-transaction', |
| 'sql-stmts/truncate', |
| 'sql-stmts/unlisten', |
| 'sql-stmts/update', |
| 'sql-stmts/vacuum', |
| 'sql-stmts/values', |
| ] |
| }, |
| |
| 'data-types', |
| 'config-params-guc-list', |
| |
| { |
| type: 'category', |
| label: 'Built-in Functions', |
| link: { |
| type: "doc", |
| id: 'functions/index', |
| }, |
| items: [ |
| 'functions/json-functions-and-operators', |
| 'functions/window-functions', |
| 'functions/advanced-aggregate-functions', |
| 'functions/text-search-functions-and-operators', |
| 'functions/range-functions-and-operators', |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'System Utilities', |
| link: { |
| type: "doc", |
| id: 'sys-utilities/index', |
| }, |
| items: [ |
| 'sys-utilities/analyzedb', |
| 'sys-utilities/clusterdb', |
| 'sys-utilities/createuser', |
| 'sys-utilities/createdb', |
| 'sys-utilities/gpaddmirrors', |
| 'sys-utilities/gpbackup', |
| 'sys-utilities/gpcheckcat', |
| 'sys-utilities/gpcheckperf', |
| 'sys-utilities/gpconfig', |
| 'sys-utilities/gpdeletesystem', |
| 'sys-utilities/gpdemo', |
| 'sys-utilities/gpexpand', |
| 'sys-utilities/gpfdist', |
| 'sys-utilities/gpinitstandby', |
| 'sys-utilities/gpinitsystem', |
| 'sys-utilities/gpload', |
| 'sys-utilities/gplogfilter', |
| 'sys-utilities/gpmemreport', |
| 'sys-utilities/gpmemwatcher', |
| 'sys-utilities/gpmovemirrors', |
| 'sys-utilities/gppkg', |
| 'sys-utilities/gprestore', |
| 'sys-utilities/gpreload', |
| 'sys-utilities/gprecoverseg', |
| 'sys-utilities/gpshrink', |
| 'sys-utilities/gpssh-exkeys', |
| 'sys-utilities/gpssh', |
| 'sys-utilities/gpstart', |
| 'sys-utilities/gpstate', |
| 'sys-utilities/gpstop', |
| 'sys-utilities/gpsync', |
| 'sys-utilities/pg-checksums', |
| 'sys-utilities/pg-config', |
| 'sys-utilities/pg-dump', |
| 'sys-utilities/pg-dumpall', |
| 'sys-utilities/pg-filedump', |
| 'sys-utilities/psql', |
| 'sys-utilities/reindexdb', |
| 'sys-utilities/vacuumdb', |
| 'sys-utilities/dropdb', |
| 'sys-utilities/dropuser', |
| 'sys-utilities/gpactivatestandby'] |
| }, |
| |
| { |
| type: 'category', |
| label: 'System Catalogs', |
| items: [ |
| { |
| type: 'category', |
| label: 'System Tables', |
| items: [ |
| 'sys-catalogs/sys-tables/gp-configuration-history', |
| 'sys-catalogs/sys-tables/gp-distribution-policy', |
| 'sys-catalogs/sys-tables/gp-fastsequence', |
| 'sys-catalogs/sys-tables/gp-id', |
| 'sys-catalogs/sys-tables/gp-partition-template', |
| 'sys-catalogs/sys-tables/gp-segment-configuration', |
| 'sys-catalogs/sys-tables/gp-version-at-initdb', |
| 'sys-catalogs/sys-tables/pg-aggregate', |
| 'sys-catalogs/sys-tables/pg-am', |
| 'sys-catalogs/sys-tables/pg-amop', |
| 'sys-catalogs/sys-tables/pg-amproc', |
| 'sys-catalogs/sys-tables/pg-appendonly', |
| 'sys-catalogs/sys-tables/pg-attribute', |
| 'sys-catalogs/sys-tables/pg-attribute-encoding', |
| 'sys-catalogs/sys-tables/pg-attridef', |
| 'sys-catalogs/sys-tables/pg-auth-members', |
| 'sys-catalogs/sys-tables/pg-authid', |
| 'sys-catalogs/sys-tables/pg-depend', |
| 'sys-catalogs/sys-tables/pg-description', |
| 'sys-catalogs/sys-tables/pg-cast', |
| 'sys-catalogs/sys-tables/pg-class', |
| 'sys-catalogs/sys-tables/pg-namespace', |
| 'sys-catalogs/sys-tables/pg-operator', |
| 'sys-catalogs/sys-tables/pg-partitioned-table', |
| 'sys-catalogs/sys-tables/pg-policy', |
| 'sys-catalogs/sys-tables/pg-proc', |
| 'sys-catalogs/sys-tables/pg-resgroup', |
| 'sys-catalogs/sys-tables/pg-resgroupcapability', |
| 'sys-catalogs/sys-tables/pg-resourcetype', |
| 'sys-catalogs/sys-tables/pg-resqueue', |
| 'sys-catalogs/sys-tables/pg-resqueuecapability', |
| 'sys-catalogs/sys-tables/pg-rewrite', |
| 'sys-catalogs/sys-tables/pg-sequence', |
| 'sys-catalogs/sys-tables/pg-shdepend', |
| 'sys-catalogs/sys-tables/pg-shdescription', |
| 'sys-catalogs/sys-tables/pg-stat-last-operation', |
| 'sys-catalogs/sys-tables/pg-stat-last-shoperation', |
| 'sys-catalogs/sys-tables/pg-statistic', |
| 'sys-catalogs/sys-tables/pg-statistic-ext', |
| 'sys-catalogs/sys-tables/pg-statistic-ext-data', |
| 'sys-catalogs/sys-tables/pg-tablespace', |
| 'sys-catalogs/sys-tables/pg-trigger', |
| 'sys-catalogs/sys-tables/pg-type', |
| 'sys-catalogs/sys-tables/pg-type-encoding', |
| 'sys-catalogs/sys-tables/pg-user-mapping', |
| ] |
| }, |
| { |
| type: 'category', |
| label: 'System Views', |
| items: [ |
| 'sys-catalogs/sys-views/gp-distributed-log', |
| 'sys-catalogs/sys-views/gp-distributed-xacts', |
| 'sys-catalogs/sys-views/gp-endpoints', |
| 'sys-catalogs/sys-views/gp-pgdatabase', |
| 'sys-catalogs/sys-views/gp-resgroup-iostats-per-host', |
| 'sys-catalogs/sys-views/gp-segment-endpoints', |
| 'sys-catalogs/sys-views/gp-session-endpoints', |
| 'sys-catalogs/sys-views/gp-settings', |
| 'sys-catalogs/sys-views/gp-stat-activity', |
| 'sys-catalogs/sys-views/gp-stat-all-indexes', |
| 'sys-catalogs/sys-views/gp-stat-archiver', |
| 'sys-catalogs/sys-views/gp-stat-progress-dtx-recovery', |
| 'sys-catalogs/sys-views/gp-suboverflowed-backend', |
| 'sys-catalogs/sys-views/pg-backend-memory-contexts', |
| 'sys-catalogs/sys-views/pg-config', |
| 'sys-catalogs/sys-views/pg-cursors', |
| 'sys-catalogs/sys-views/pg-file-settings', |
| 'sys-catalogs/sys-views/pg-replication-origin-status', |
| 'sys-catalogs/sys-views/pg-replication-slots', |
| 'sys-catalogs/sys-views/pg-stat-all-tables', |
| 'sys-catalogs/sys-views/pg-stat-bgwriter', |
| 'sys-catalogs/sys-views/pg-stat-database-conflicts', |
| 'sys-catalogs/sys-views/pg-stat-database', |
| 'sys-catalogs/sys-views/pg-stat-gssapi', |
| 'sys-catalogs/sys-views/pg-stat-operations', |
| 'sys-catalogs/sys-views/pg-stat-progress-analyze', |
| 'sys-catalogs/sys-views/pg-stat-progress-basebackup', |
| 'sys-catalogs/sys-views/pg-stat-progress-cluster', |
| 'sys-catalogs/sys-views/pg-stat-progress-copy', |
| 'sys-catalogs/sys-views/pg-stat-progress-create-index' |
| ] |
| }, |
| 'sys-catalogs/gp_toolkit' |
| ] |
| } |
| ] |
| }, |
| |
| { |
| type: 'category', |
| label: 'Tutorials', |
| items: [ |
| 'tutorials/crash-course', |
| { |
| type: 'category', |
| label: 'Quick Trial Lessons', |
| link: { |
| type: 'doc', |
| id: 'tutorials/quick-trial-lessons/index', |
| }, |
| items: [ |
| 'tutorials/quick-trial-lessons/introduction-to-database-and-cloudberry-architecture', |
| 'tutorials/quick-trial-lessons/introduction-to-cloudberry-in-database-analytics', |
| 'tutorials/quick-trial-lessons/create-users-and-roles', |
| 'tutorials/quick-trial-lessons/create-and-prepare-database', |
| 'tutorials/quick-trial-lessons/create-tables', |
| 'tutorials/quick-trial-lessons/data-loading', |
| 'tutorials/quick-trial-lessons/queries-and-performance-tuning', |
| 'tutorials/quick-trial-lessons/backup-and-recovery-operations', |
| ], |
| }, |
| { |
| type: 'category', |
| label: 'Product Principles', |
| items: [ |
| 'tutorials/product-principles/about-mvcc', |
| 'tutorials/product-principles/about-statistics', |
| 'tutorials/product-principles/about-data-loading', |
| 'tutorials/product-principles/about-ha', |
| 'tutorials/product-principles/about-utilities', |
| ], |
| }, |
| { |
| type: 'category', |
| label: 'Best Practices', |
| link: { |
| type: 'doc', |
| id: 'tutorials/best-practices/index', |
| }, |
| items: [ |
| 'tutorials/best-practices/schema-design-best-practices', |
| 'tutorials/best-practices/load-data-best-practices', |
| 'tutorials/best-practices/db-encryption-best-practices', |
| 'tutorials/best-practices/high-availability-best-practices', |
| 'tutorials/best-practices/resource-group-best-practices', |
| 'tutorials/best-practices/system-configuration-best-practices', |
| 'tutorials/best-practices/system-monitor-and-maintain-best-practices', |
| 'tutorials/best-practices/manage-bloat', |
| 'tutorials/best-practices/identify-and-mitigate-heap-table-performance-issues', |
| 'tutorials/best-practices/security-best-practices' |
| ], |
| }, |
| ] |
| } |
| |
| ] |
| } |
| |
| export default sidebars; |
