Hello team,
We've been building a index maintenance scripts but in the function it doesn't work with concurrently, is there a way for manipulate that ? Just for example ; The reindexes are working without function. Have a nice day!
We've been building a index maintenance scripts but in the function it doesn't work with concurrently, is there a way for manipulate that ? Just for example ; The reindexes are working without function. Have a nice day!
select index_stat.test ();
CREATE OR REPLACE FUNCTION index_stat.test()
RETURNS void
LANGUAGE plpgsql
AS $function$
begin
REINDEX INDEX CONCURRENTLY "players_id_idx";
commit;
REINDEX INDEX CONCURRENTLY "players_about_idx";
commit;
end;
$function$
;
