summaryrefslogtreecommitdiff
path: root/src/test/regress
diff options
context:
space:
mode:
authorTom Lane2007-09-24 03:12:23 +0000
committerTom Lane2007-09-24 03:12:23 +0000
commit48f7e6439568e5d665f622e2973becc50a86b64a (patch)
tree61e36a6230783a6e8374e72b247fb3597f4d5a3f /src/test/regress
parent02138357ffc8c41a3d646035368712a5394f1f5f (diff)
Simplify and rename some GUC variables, per various recent discussions:
* stats_start_collector goes away; we always start the collector process, unless prevented by a problem with setting up the stats UDP socket. * stats_reset_on_server_start goes away; it seems useless in view of the availability of pg_stat_reset(). * stats_block_level and stats_row_level are merged into a single variable "track_counts", which controls all reports sent to the collector process. * stats_command_string is renamed to track_activities. * log_autovacuum is renamed to log_autovacuum_min_duration to better reflect its meaning. The log_autovacuum change is not a compatibility issue since it didn't exist before 8.3 anyway. The other changes need to be release-noted.
Diffstat (limited to 'src/test/regress')
-rw-r--r--src/test/regress/expected/stats.out9
-rw-r--r--src/test/regress/sql/stats.sql6
2 files changed, 4 insertions, 11 deletions
diff --git a/src/test/regress/expected/stats.out b/src/test/regress/expected/stats.out
index af0f630a8da..00811e2145f 100644
--- a/src/test/regress/expected/stats.out
+++ b/src/test/regress/expected/stats.out
@@ -5,9 +5,9 @@
-- populated (by create_misc) and indexed (by create_index).
--
-- conditio sine qua non
-SHOW stats_start_collector; -- must be on
- stats_start_collector
------------------------
+SHOW track_counts; -- must be on
+ track_counts
+--------------
on
(1 row)
@@ -56,9 +56,6 @@ begin
extract(epoch from clock_timestamp() - start_time);
end
$$ language plpgsql;
--- enable statistics
-SET stats_block_level = on;
-SET stats_row_level = on;
-- do a seqscan
SELECT count(*) FROM tenk2;
count
diff --git a/src/test/regress/sql/stats.sql b/src/test/regress/sql/stats.sql
index 9900b9114a5..4a72a949f29 100644
--- a/src/test/regress/sql/stats.sql
+++ b/src/test/regress/sql/stats.sql
@@ -6,7 +6,7 @@
--
-- conditio sine qua non
-SHOW stats_start_collector; -- must be on
+SHOW track_counts; -- must be on
-- wait to let any prior tests finish dumping out stats;
-- else our messages might get lost due to contention
@@ -51,10 +51,6 @@ begin
end
$$ language plpgsql;
--- enable statistics
-SET stats_block_level = on;
-SET stats_row_level = on;
-
-- do a seqscan
SELECT count(*) FROM tenk2;
-- do an indexscan