Oushu产品简介¶
Oushu有三个主要产品：Oushu Lava（简称Lava），Oushu Database（简称OushuDB）与LittleBoy。
下面我们分别详细介绍各个产品。
- Oushu Lava
- Oushu Database
- Release Notes
- Oushu Database 4.0.1.0 新特性 (发布日期:2020年8月28日)
- Oushu Database 4.0.0.0 新特性 (发布日期:2020年7月17日)
- Oushu Database 3.4.0.0新特性 (发布日期:2020年2月25日)
- Oushu Database 3.3.1.2特性 (发布日期:2020年1月3日)
- Oushu Database 4.0 Beta 新特性 (发布日期:2019年9月12日)
- Oushu Database 3.3.1.0新特性 (发布日期:2019年10月25日)
- Oushu Database 3.3.0.1新特性 (发布日期:2019年3月6日)
- Oushu Database 3.3.0.0新特性 (发布日期:2019年2月21日)
- Oushu Database 3.2.0.0新特性 (发布日期:2018年10月8日)
- Oushu Database 3.1.2.1新特性 (发布日期:2018年10月8日)
- Oushu Database 3.1.2新特性 (发布日期:2018年6月6日)
- Oushu Database 3.1.1新特性 (发布日期:2018年3月28日)
- Oushu Database 3.1.0新特性 (发布日期:2018年3月6日)
- Oushu Database 3.0.1新特性 (发布日期:2017年10月30日)
- Oushu Database 3.0新特性 (发布日期:2017年9月20日)
- Oushu Database 2.2.0新特性 (发布日期:2017年6月19日)
- Oushu Database 2.1.1新特性 (发布日期:2017年5月10日)
- Oushu Database 2.1.0新特性 (发布日期:2017年3月24日)
- Oushu Database 2.0.1新特性 (发布日期:2017年1月20日)
- 产品介绍
- 安装与升级
- 用户指南
- 数据定义
- 数据插入／删除／更新
- 数据查询
- SQL 语法
- 数据类型
- 函数和操作符
- 类型转换
- 查询优化
- 管理数据库访问
- 数据导入导出
- 编程接口
- 管理指南
- 参考手册
- Reference：commands
- Reference: SQL
- ABORT
- ALTER AGGREGATE
- ALTER DATABASE
- ALTER EXTERNAL TABLE
- ALTER FUNCTION
- ALTER GROUP
- ALTER OPERATOR
- ALTER RESOURCE QUEUE
- ALTER ROLE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER TABLE
- ALTER TYPE
- ALTER USER
- ANALYZE
- BEGIN
- CHECKPOINT
- CLOSE
- COMMENT
- COMMIT
- COPY
- CREATE AGGREGATE
- CREATE CAST
- CREATE DATABASE
- CREATE EXTERNAL TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INDEX
- CREATE LANGUAGE
- CREATE OPERATOR
- CREATE OPERATOR CLASS
- CREATE RESOURCE QUEUE
- CREATE ROLE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLESPACE
- CREATE TYPE
- CREATE USER
- CREATE VIEW
- DEALLOCATE
- DECLARE
- DELETE
- DROP AGGREGATE
- DROP CAST
- DROP DATABASE
- DROP EXTERNAL TABLE
- DROP FILESPACE
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP OPERATOR
- DROP OPERATOR CLASS
- DROP OWNED
- DROP RESOURCE QUEUE
- DROP ROLE
- DROP SCHEMA
- DROP SEQUENCE
- DROP TABLE
- DROP TABLESPACE
- DROP TYPE
- DROP USER
- DROP VIEW
- END
- EXECUTE
- EXPLAIN
- FETCH
- GRANT
- INSERT
- LOCK
- MOVE
- PREPARE
- REASSIGN OWNED
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET ROLE
- SET SESSION AUTHORIZATION
- SHOW
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- Reference: parameters (GUC)
- add_missing_from
- application_name
- array_nulls
- authentication_timeout
- backslash_quote
- block_size
- bonjour_name
- check_function_bodies
- client_encoding
- client_min_messages
- clusterName
- cpu_index_tuple_cost
- cpu_operator_cost
- cpu_tuple_cost
- cursor_tuple_fraction
- custom_variable_classes
- DateStyle
- db_user_namespace
- deadlock_timeout
- debug_assertions
- debug_pretty_print
- debug_print_parse
- debug_print_plan
- debug_print_prelim_plan
- debug_print_rewritten
- debug_print_slice_table
- debug_udf_plan
- default_hash_table_bucket_number
- default_magma_hash_table_nvseg_per_seg
- default_statement_mem
- default_statistics_target
- default_tablespace
- default_table_format
- default_transaction_isolation
- default_transaction_read_only
- dfs_url
- dynamic_library_path
- effective_cache_size
- enable_bitmapscan
- enable_groupagg
- enable_hashagg
- enable_hashjoin
- enable_indexscan
- enable_magma_bitmapscan
- enable_magma_indexonlyscan
- enable_magma_indexscan
- enable_master_auto_ha
- enable_mergejoin
- enable_nestloop
- enable_pg_stat_activity_history
- enable_secure_filesystem
- enable_seqscan
- enable_sort
- enable_tidscan
- escape_string_warning
- explain_memory_verbosity
- explain_pretty_print
- extra_float_digits
- from_collapse_limit
- gp_adjust_selectivity_for_outerjoins
- gp_analyze_relative_error
- gp_autostats_mode
- gp_autostats_on_change_threshold
- gp_backup_directIO
- gp_backup_directIO_read_chunk_mb
- gp_cached_segworkers_threshold
- gp_command_count
- gp_connections_per_thread
- gp_debug_linger
- gp_dynamic_partition_pruning
- gp_enable_agg_distinct
- gp_enable_agg_distinct_pruning
- gp_enable_direct_dispatch
- gp_enable_fallback_plan
- gp_enable_fast_sri
- gp_enable_groupext_distinct_gather
- gp_enable_groupext_distinct_pruning
- gp_enable_multiphase_agg
- gp_enable_predicate_propagation
- gp_enable_preunique
- gp_enable_sequential_window_plans
- gp_enable_sort_distinct
- gp_enable_sort_limit
- gp_external_enable_exec
- gp_external_grant_privileges
- gp_external_max_segs
- gp_hashjoin_tuples_per_bucket
- gp_idf_deduplicate
- gp_interconnect_fc_method
- gp_interconnect_hash_multiplier
- gp_interconnect_queue_depth
- gp_interconnect_setup_timeout
- gp_interconnect_snd_queue_depth
- gp_interconnect_type
- gp_log_format
- gp_max_csv_line_length
- gp_max_databases
- gp_max_filespaces
- gp_max_packet_size
- gp_max_plan_size
- gp_max_tablespaces
- gp_motion_cost_per_row
- gp_reject_percent_threshold
- gp_reraise_signal
- gp_role
- gp_safefswritesize
- gp_segment_connect_timeout
- gp_segments_for_planner
- gp_session_id
- gp_set_proc_affinity
- gp_set_read_only
- gp_statistics_pullup_from_child_partition
- gp_statistics_use_fkeys
- gp_vmem_idle_resource_timeout
- gp_vmem_protect_segworker_cache_limit
- gp_workfile_checksumming
- gp_workfile_compress_algorithm
- gp_workfile_limit_files_per_query
- gp_workfile_limit_per_query
- gp_workfile_limit_per_segment
- ha_zookeeper_quorum
- hawq_auto_ha_timeout
- hawq_dfs_url
- hawq_global_rm_type
- hawq_hashjoin_bloomfilter
- hawq_hashjoin_bloomfilter_max_memory_size
- hawq_hashjoin_bloomfilter_ratio
- hawq_hashjoin_bloomfilter_sampling_number
- hawq_init_with_hdfs
- hawq_master_address_host
- hawq_master_address_port
- hawq_master_directory
- hawq_master_temp_directory
- hawq_re_memory_overcommit_max
- hawq_rm_cluster_report_period
- hawq_rm_force_alterqueue_cancel_queued_request
- hawq_rm_master_port
- hawq_rm_memory_limit_perseg
- hawq_rm_min_resource_perseg
- hawq_rm_nresqueue_limit
- hawq_rm_nslice_perseg_limit
- hawq_rm_nvcore_limit_perseg
- hawq_rm_nvseg_perquery_limit
- hawq_rm_nvseg_perquery_perseg_limit
- hawq_rm_nvseg_variance_amon_seg_limit
- hawq_rm_rejectrequest_nseg_limit
- hawq_rm_resource_idle_timeout
- hawq_rm_return_percent_on_overcommit
- hawq_rm_segment_heartbeat_interval
- hawq_rm_segment_port
- hawq_rm_stmt_nvseg
- hawq_rm_stmt_vseg_memory
- hawq_rm_tolerate_nseg_limit
- hawq_rm_yarn_address
- hawq_rm_yarn_app_name
- hawq_rm_yarn_queue_name
- hawq_rm_yarn_scheduler_address
- hawq_rps_check_local_interval
- hawq_segment_address_port
- hawq_segment_directory
- integer_datetimes
- IntervalStyle
- join_collapse_limit
- krb_caseins_users
- krb_server_keyfile
- krb_srvname
- lc_collate
- lc_ctype
- lc_messages
- lc_monetary
- lc_numeric
- lc_time
- listen_addresses
- local_preload_libraries
- log_autostats
- log_connections
- log_disconnections
- log_dispatch_stats
- log_duration
- log_error_verbosity
- log_executor_stats
- log_hostname
- log_min_duration_statement
- log_min_error_statement
- log_min_messages
- log_parser_stats
- log_planner_stats
- log_rotation_age
- log_rotation_size
- log_statement
- log_statement_stats
- log_timezone
- log_truncate_on_rotation
- maintenance_work_mem
- magma_nodes_url
- max_appendonly_tables
- max_connections
- max_files_per_process
- max_fsm_pages
- max_fsm_relations
- max_function_args
- max_identifier_length
- max_index_keys
- max_locks_per_transaction
- max_prepared_transactions
- max_stack_depth
- new_executor
- new_executor_enable_external_sort
- new_executor_enable_partitioned_hashagg
- new_executor_enable_partitioned_hashjoin
- new_executor_ic_tcp_client_limit_per_query_per_segment
- new_executor_partitioned_hash_recursive_depth_limit
- new_executor_runtime_filter_mode
- new_interconnect_type
- optimizer
- optimizer_analyze_root_partition
- optimizer_minidump
- optimizer_parts_to_force_sort_on_insert
- optimizer_prefer_scalar_dqa_multistage_agg
- password_encryption
- password_hash_algorithm
- pgstat_track_activity_query_size
- pljava_classpath
- pljava_release_lingering_savepoints
- pljava_statement_cache_size
- pljava_vmoptions
- port
- random_page_cost
- readable_external_table_timeout
- regex_flavor
- runaway_detector_activation_percent
- search_path
- seg_max_connections
- seq_page_cost
- server_encoding
- server_version
- server_version_num
- share_input_scan_wait_lockfile_timeout
- shared_buffers
- shared_preload_libraries
- ssl
- ssl_ciphers
- standard_conforming_strings
- statement_timeout
- superuser_reserved_connections
- tcp_keepalives_count
- tcp_keepalives_idle
- tcp_keepalives_interval
- temp_buffers
- TimeZone
- timezone_abbreviations
- track_activities
- track_counts
- transaction_isolation
- transaction_read_only
- transform_null_equals
- unix_socket_directory
- unix_socket_group
- unix_socket_permissions
- update_process_title
- vacuum_cost_delay
- vacuum_cost_limit
- vacuum_cost_page_dirty
- vacuum_cost_page_miss
- vacuum_freeze_min_age
- writable_external_table_bufsize
- xid_stop_limit
- Reference: magma (GUC)
- nodes_file
- node_data_directory
- node_log_directory
- node_address_port
- magma_datadir_capacity
- magma_range_number
- magma_replica_number
- blacklist_log_threshold
- compact_cleanup_worker_limit_perrg
- compact_data_worker_limit_pernode
- compact_data_worker_limit_perrg
- compact_trigger_ap_ratio_limit
- compact_trigger_tp_ratio_limit
- fts_node_timeout
- nbuffers
- raft_election_timeout
- rg_checkpoint_threshold
- Release Notes
- Oushu LittleBoy