Disalbe autovacuum during regression test

[pgdbmsstats/pg_dbms_stats.git] / expected / init-common.out

diff --git a/expected/init-common.out b/expected/init-common.out
index 71ddfa0..0b93da8 100644 (file)
--- a/expected/init-common.out
+++ b/expected/init-common.out
@@ -11,19 +11,20 @@ SET client_min_messages = warning;
 DROP ROLE IF EXISTS regular_user;
 CREATE ROLE regular_user LOGIN;
 SET client_min_messages = fatal;
-CREATE ROLE postgres SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
+DROP ROLE IF EXISTS super_user;
+CREATE ROLE super_user SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
 -- create object
-CREATE TABLE pt0(id integer, day date);
+CREATE TABLE pt0(id integer, day date) WITH (autovacuum_enabled = 'false');
 CREATE INDEX pt0_idx ON pt0(id);
-CREATE TABLE st0(id integer, name char(5));
+CREATE TABLE st0(id integer, name char(5)) WITH (autovacuum_enabled = 'false');
 CREATE INDEX st0_idx ON st0(id);
-CREATE TABLE st1(val integer, str text);
+CREATE TABLE st1(val integer, str text) WITH (autovacuum_enabled = 'false');
 CREATE SCHEMA s0;
-CREATE TABLE s0.st0(id integer, num integer);
+CREATE TABLE s0.st0(id integer, num integer) WITH (autovacuum_enabled = 'false');
 CREATE INDEX st0_idx ON s0.st0(id);
-CREATE TABLE s0.st1() INHERITS(s0.st0);
+CREATE TABLE s0.st1() INHERITS(s0.st0) WITH (autovacuum_enabled = 'false');
 CREATE INDEX st1_idx ON s0.st1(id);
-CREATE TABLE s0.st2(id integer, txt text);
+CREATE TABLE s0.st2(id integer, txt text) WITH (autovacuum_enabled = 'false');
 CREATE INDEX st2_idx ON s0.st2(id);
 CREATE VIEW sv0 AS
     SELECT st0.id, st0.num, st2.txt
@@ -32,7 +33,7 @@ CREATE VIEW sv0 AS
 CREATE TYPE s0.sc0 AS (num integer, txt text);
 CREATE SEQUENCE s0.ss0 START 1;
 CREATE SCHEMA s1;
-CREATE TABLE s1.st0(id integer, num integer);
+CREATE TABLE s1.st0(id integer, num integer) WITH (autovacuum_enabled = 'false');
 CREATE SCHEMA s2;
 GRANT USAGE ON SCHEMA s0 TO regular_user;
 GRANT SELECT ON TABLE s0.st2 TO regular_user;
@@ -40,6 +41,12 @@ CREATE TYPE complex AS (
      r double precision,
      i double precision
 );
+-- updating relation_stats_locked leads to merged stats caches
+-- See StatsCacheRelCallback() in pg_dbms_stats.c for details.
+CREATE FUNCTION load_merged_stats() RETURNS void AS $$
+  UPDATE dbms_stats.relation_stats_locked SET relpages = relpages;
+$$
+LANGUAGE sql;
 CREATE FUNCTION inform(VARIADIC arr text[]) RETURNS int AS $$
 DECLARE
     str text := 'arguments are ';
@@ -59,13 +66,22 @@ BEGIN
     RETURN 1;
 END;
 $$LANGUAGE plpgsql;
+-- Table or index fetches will take place if stats merge performed.
 CREATE VIEW lockd_io AS
-       SELECT relname, heap_blks_read hbr, heap_blks_hit hbh,
-              idx_blks_read ibr, idx_blks_hit ibh
+       SELECT relname,
+              heap_blks_read + heap_blks_hit +
+              idx_blks_read  + idx_blks_hit  > 0  fetches
          FROM pg_statio_user_tables
         WHERE schemaname = 'dbms_stats'
-          AND relname LIKE '%stats_locked'
+          AND relname LIKE '%\_stats_locked'
         ORDER BY relid;
+CREATE VIEW internal_locks AS
+    SELECT relation::regclass, mode
+      FROM pg_locks
+      WHERE relation::regclass::text LIKE 'dbms_stats.%\_locked'
+         OR relation::regclass::text LIKE 'dbms_stats.backup_history'
+         OR relation::regclass::text LIKE 'dbms_stats.%\_backup'
+      ORDER BY relation::regclass::text, mode;
 -- load data
 INSERT INTO st0 VALUES (1, 'test'), (2, 'test');
 INSERT INTO st1 SELECT i % 3, i % 3 FROM generate_series(1, 10000) t(i);