Revision 14128
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/util.sql | ||
---|---|---|
845 | 845 |
|
846 | 846 |
|
847 | 847 |
-- |
848 |
-- Name: cluster(regclass, regclass); Type: FUNCTION; Schema: util; Owner: - |
|
849 |
-- |
|
850 |
|
|
851 |
CREATE FUNCTION cluster(table_ regclass, index regclass) RETURNS void |
|
852 |
LANGUAGE sql |
|
853 |
AS $_$ |
|
854 |
SELECT util.eval($$CLUSTER $$||table_||$$ USING $$||quote_ident(util.name(index))) |
|
855 |
$_$; |
|
856 |
|
|
857 |
|
|
858 |
-- |
|
859 |
-- Name: FUNCTION cluster(table_ regclass, index regclass); Type: COMMENT; Schema: util; Owner: - |
|
860 |
-- |
|
861 |
|
|
862 |
COMMENT ON FUNCTION cluster(table_ regclass, index regclass) IS ' |
|
863 |
idempotent, but reclusters each time |
|
864 |
'; |
|
865 |
|
|
866 |
|
|
867 |
-- |
|
848 | 868 |
-- Name: cluster_index(regclass); Type: FUNCTION; Schema: util; Owner: - |
849 | 869 |
-- |
850 | 870 |
|
Also available in: Unified diff
schemas/util.sql: added cluster(), which reclusters each time