Documentation for HyperSQL-PostgreSQL

• 1. 지원 사항
• 2. 검증 환경
• 3. 문서 목차
  • 3.1. admin
  • 3.2. cloud_enviroment
  • 3.3. command
  • 3.4. extension
  • 3.5. install
  • 3.6. interface
  • 3.7. internal
  • 3.8. sql
  • 3.9. Opensource Tool
• 4. PostgreSQL 제약사항
• 5. PostgreSQL Client Interfaces

HyperSQL-PostgreSQL의 문서들을 제공하는 Repository입니다.

1. 지원 사항

• HyperSQL- PostgreSQL은 Postgresql-14 기준으로 지원합니다.(2022.06.10 기준)

2. 검증 환경

• OS

  • CentOS Linux release 7.6.1810 (Core)

• Binary

  • postgres (PostgreSQL) 14.2

  • pg_ctl (PostgreSQL) 14.2

  • psql (PostgreSQL) 14.2

• OpenSource

  • barman version 2.19

  • bucardo version 5.6.0

  • pgBackrest version 2.3.9

  • pgpool-II-pg11 4.3.1

  • pgbadger version 11.7

  • pgbouncer 1.17.0

  • pgAdmin4 version 6.8

  • slony-i verison 2.2.10

  • ora2pg version 12.2

3. 문서 목차

3.1. admin

Backup	Backup 문서
Logging	Logging 문서
Parameter	Parameter 문서
Release	Release 문서
Restore	Restore 문서
Upgrade	Upgrade 문서

3.2. cloud_enviroment

Docker	Docker 문서
Kubernetes	Kubernetes 문서

3.3. command

initdb	initdb 문서
pg_basebackup	pg_basebackup 문서
pg_dump	pg_dump 문서
pg_dumpall	pg_dumpall 문서
pg_restore	pg_restore 문서
pg_upgrade	pg_upgrade 문서
pgbench	pgbench 문서
psql	psql 문서

3.4. extension

pg_agent	pg_agent 문서
pg_cron	pg_cron 문서
pg_partman	pg_partman 문서
bgw_replstatus	bgw_replstatus 문서
pg_stat_statements	pg_stat_statements 문서
pgaudit	pgaudit 문서
pgcrypto	pgcrypto 문서
postgis	postgis 문서
postgres_fdw	postgres_fdw 문서
dblink	dblink 문서

3.5. install

Install	HyperSQL-PostgreSQL 표준 설치 문서
Replication Install	Replication 설치 문서

3.6. interface

.NET	.NET interface 문서
DB_link	DB_link 문서
Go	Go 문서
JDBC	JDBC 문서
node.js	node.js 문서
ODBC	ODBC 문서
Perl	Perl 문서
Python	Python 문서
TCL	TCL 문서

3.7. internal

Analyze	Analyze 문서
BackgroundWriter	BackgroundWriter 문서
Checkpointer	Checkpointer 문서

3.8. sql

Partition Table	Partition Table 문서
VACUUM	VACUUM 문서

3.9. Opensource Tool

pg_barman	Backup & Restore하기 위한 Opensource
pgBackrest	pgBackrest
bucardo	Multi-Active 구성을 위한 Opensource
pgbadger	Monitoring을 위한 Opensource
ora2pg	Migration 구성을 위한 Opensource
pgAdmin4
pgbouncer	Connection Pool을 관리하기 위한 Opensourc
pgpool	HA 구성을 위한 Opensourcee
slony-i	slony-i

4. PostgreSQL 제약사항

PostgreSQL 공식 문서 참조

Item	Upper Limit	Comment
Database size	Unlimited
Number of databases	4,294,950,911
Relations per database	1,431,650,303
Relation size	32 TB	with the default BLCKSZ of 8192 bytes
Rows per table	Limited by the number of tuples that can fit onto 4,294,967,295 pages
Columns per table	1600	Further limited by tuple size fitting on a single page
Filed size	1 GB
Identifier length	63 bytes	can be increased by recompiling PostgreSQL
Indexes per table	Unlimited	constrained by maximum relations per database
Columns per index	32	Can be increased by recompiling PostgreSQL
Partition keys	32	Can be increased by recompiling PostgreSQL

5. PostgreSQL Client Interfaces

Name	Language	Comments	Website
DBD::Pg	Perl	Perl DBI driver	https://metacpan.org/release/DBD-Pg
JDBC	Java	Type 4 JDBC driver	https://jdbc.postgresql.org/
libpqxx	C++	C++ interface	https://pqxx.org/
node-postgres	JavaScript	Node.js driver	https://node-postgres.com/
Npgsql	.NET	.NET data provider	https://www.npgsql.org/
pq	Go	Pure Go driver for Go’s database/sql	https://github.com/lib/pq
psqlODBC	ODBC	ODBC driver	https://odbc.postgresql.org/
psycopg	Python	DB API 2.0-compliant	https://www.psycopg.org/
pgtcl	Tcl		https://github.com/flightaware/Pgtcl
pgtclng	Tcl		https://sourceforge.net/projects/pgtclng/