granicus.if.org Git - postgresql/commit

]> granicus.if.org Git - postgresql/commit

author	Simon Riggs <simon@2ndQuadrant.com>
	Fri, 15 May 2015 18:37:10 +0000 (14:37 -0400)
committer	Simon Riggs <simon@2ndQuadrant.com>
	Fri, 15 May 2015 18:37:10 +0000 (14:37 -0400)
commit	f6d208d6e51810c73f0e02c477984a6b44627f11
tree	99d540d0b7bda73ff60479f15444f554403d4679	tree \| snapshot
parent	11a83bbedd73800db70f6f2af5a8eb10d15d39d7	commit \| diff

TABLESAMPLE, SQL Standard and extensible

Add a TABLESAMPLE clause to SELECT statements that allows
user to specify random BERNOULLI sampling or block level
SYSTEM sampling. Implementation allows for extensible
sampling functions to be written, using a standard API.
Basic version follows SQLStandard exactly. Usable
concrete use cases for the sampling API follow in later
commits.

Petr Jelinek

Reviewed by Michael Paquier and Simon Riggs

66 files changed:

contrib/file_fdw/file_fdw.c		diff \| blob \| history
contrib/postgres_fdw/postgres_fdw.c		diff \| blob \| history
doc/src/sgml/catalogs.sgml		diff \| blob \| history
doc/src/sgml/ref/select.sgml		diff \| blob \| history
src/backend/access/Makefile		diff \| blob \| history
src/backend/access/heap/heapam.c		diff \| blob \| history
src/backend/access/tablesample/Makefile	[new file with mode: 0644]	blob
src/backend/access/tablesample/bernoulli.c	[new file with mode: 0644]	blob
src/backend/access/tablesample/system.c	[new file with mode: 0644]	blob
src/backend/access/tablesample/tablesample.c	[new file with mode: 0644]	blob
src/backend/catalog/Makefile		diff \| blob \| history
src/backend/commands/analyze.c		diff \| blob \| history
src/backend/commands/explain.c		diff \| blob \| history
src/backend/executor/Makefile		diff \| blob \| history
src/backend/executor/execAmi.c		diff \| blob \| history
src/backend/executor/execCurrent.c		diff \| blob \| history
src/backend/executor/execProcnode.c		diff \| blob \| history
src/backend/executor/nodeSamplescan.c	[new file with mode: 0644]	blob
src/backend/nodes/copyfuncs.c		diff \| blob \| history
src/backend/nodes/equalfuncs.c		diff \| blob \| history
src/backend/nodes/nodeFuncs.c		diff \| blob \| history
src/backend/nodes/outfuncs.c		diff \| blob \| history
src/backend/nodes/readfuncs.c		diff \| blob \| history
src/backend/optimizer/path/allpaths.c		diff \| blob \| history
src/backend/optimizer/path/costsize.c		diff \| blob \| history
src/backend/optimizer/plan/createplan.c		diff \| blob \| history
src/backend/optimizer/plan/planner.c		diff \| blob \| history
src/backend/optimizer/plan/setrefs.c		diff \| blob \| history
src/backend/optimizer/plan/subselect.c		diff \| blob \| history
src/backend/optimizer/util/pathnode.c		diff \| blob \| history
src/backend/parser/gram.y		diff \| blob \| history
src/backend/parser/parse_clause.c		diff \| blob \| history
src/backend/parser/parse_func.c		diff \| blob \| history
src/backend/rewrite/rewriteHandler.c		diff \| blob \| history
src/backend/utils/adt/ruleutils.c		diff \| blob \| history
src/backend/utils/cache/lsyscache.c		diff \| blob \| history
src/backend/utils/cache/syscache.c		diff \| blob \| history
src/backend/utils/misc/sampling.c		diff \| blob \| history
src/include/access/heapam.h		diff \| blob \| history
src/include/access/relscan.h		diff \| blob \| history
src/include/access/tablesample.h	[new file with mode: 0644]	blob
src/include/catalog/indexing.h		diff \| blob \| history
src/include/catalog/pg_proc.h		diff \| blob \| history
src/include/catalog/pg_tablesample_method.h	[new file with mode: 0644]	blob
src/include/executor/nodeSamplescan.h	[new file with mode: 0644]	blob
src/include/nodes/execnodes.h		diff \| blob \| history
src/include/nodes/nodes.h		diff \| blob \| history
src/include/nodes/parsenodes.h		diff \| blob \| history
src/include/nodes/plannodes.h		diff \| blob \| history
src/include/optimizer/cost.h		diff \| blob \| history
src/include/optimizer/pathnode.h		diff \| blob \| history
src/include/parser/kwlist.h		diff \| blob \| history
src/include/parser/parse_func.h		diff \| blob \| history
src/include/port.h		diff \| blob \| history
src/include/utils/lsyscache.h		diff \| blob \| history
src/include/utils/rel.h		diff \| blob \| history
src/include/utils/sampling.h		diff \| blob \| history
src/include/utils/syscache.h		diff \| blob \| history
src/port/erand48.c		diff \| blob \| history
src/test/regress/expected/rowsecurity.out		diff \| blob \| history
src/test/regress/expected/sanity_check.out		diff \| blob \| history
src/test/regress/expected/tablesample.out	[new file with mode: 0644]	blob
src/test/regress/parallel_schedule		diff \| blob \| history
src/test/regress/serial_schedule		diff \| blob \| history
src/test/regress/sql/rowsecurity.sql		diff \| blob \| history
src/test/regress/sql/tablesample.sql	[new file with mode: 0644]	blob

Unnamed repository; edit this file 'description' to name the repository.

RSS Atom