Furkan Ençkü encku

🎯

Focusing

not fan of any programming language.

encku / psql-9.6-views-benchmark

Created February 14, 2017 17:51

PostgreSQL 9.6 Views vs. Materialized Views Benchmark

	CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

	-- Materialized view hook triggers
	CREATE OR REPLACE FUNCTION refresh_materialized_view()
	RETURNS TRIGGER
	LANGUAGE plpgsql
	AS $$
	BEGIN
	REFRESH MATERIALIZED VIEW user_emails;
	RETURN null;