OSDN Git Service

Drop very large table "utf8_tbl" after it's used in regression test.
authorMasaoFujii <masao.fujii@gmail.com>
Tue, 8 Sep 2015 05:55:28 +0000 (14:55 +0900)
committerMasaoFujii <masao.fujii@gmail.com>
Tue, 8 Sep 2015 05:55:28 +0000 (14:55 +0900)
This is for reducing the performance impact on subsequent checkpoint.

expected/pg_bigm.out
sql/pg_bigm.sql

index 1ba04d9..194c602 100644 (file)
@@ -1839,3 +1839,5 @@ SELECT * FROM utf8_tbl
 ------+------
 (0 rows)
 
+-- Drop utf8_tbl to reduce the impact on subsequent CHECKPOINT
+DROP TABLE utf8_tbl;
index 62ae4a3..48309d1 100644 (file)
@@ -606,3 +606,6 @@ EXPLAIN (costs off) SELECT * FROM utf8_tbl
 -- Text for NULL
 SELECT * FROM utf8_tbl
     WHERE pgs2norm(col1) LIKE likequery(pgs2norm(NULL)) ORDER BY code;
+
+-- Drop utf8_tbl to reduce the impact on subsequent CHECKPOINT
+DROP TABLE utf8_tbl;