GitHub - guanghetv/postgres-feature

使用 tmp table 优化分布式 join查询

保证分片数据的外键约束
分片数据避免remote表的join操作
实时分析的多分片数据汇总

create a view based on the another view, create business cache layer

Name		Name	Last commit message	Last commit date
Latest commit History 191 Commits
Copying Rows Between PostgreSQL Databases.sh		Copying Rows Between PostgreSQL Databases.sh
README.md		README.md
aggregate-expressions.md		aggregate-expressions.md
brin.md		brin.md
calling-functions.md		calling-functions.md
case.md		case.md
cluster.md		cluster.md
constant.md		constant.md
constructor.md		constructor.md
copy-command.md		copy-command.md
create_table.md		create_table.md
cte.md		cte.md
cursor.md		cursor.md
curve-fitting.md		curve-fitting.md
distinct.md		distinct.md
exists.md		exists.md
expression-evaluation-rule.md		expression-evaluation-rule.md
fdw.md		fdw.md
filter.md		filter.md
full-text-searching.md		full-text-searching.md
gin.md		gin.md
grouping.md		grouping.md
index.md		index.md
index_maintenance.md		index_maintenance.md
lateral.md		lateral.md
microservice.md		microservice.md
monitoring.md		monitoring.md
mvcc.md		mvcc.md
notify-listen.md		notify-listen.md
parallel-query.md		parallel-query.md
partition-table.md		partition-table.md
performance.md		performance.md
postgis.md		postgis.md
prepare.md		prepare.md
query-plan.md		query-plan.md
rolap.md		rolap.md
role-manage.md		role-manage.md
table-functions.md		table-functions.md
table-join.md		table-join.md
tablesample.md		tablesample.md
team_manage.md		team_manage.md
transaction.md		transaction.md
upsert.md		upsert.md
vacuum.md		vacuum.md
view.md		view.md
window-function.md		window-function.md

guanghetv/postgres-feature