diff options
| author | Heikki Linnakangas | 2018-05-02 07:12:15 +0000 |
|---|---|---|
| committer | Heikki Linnakangas | 2018-05-02 07:15:04 +0000 |
| commit | 334cb5b2abd1e2169ae5194636df119cdd3f7aae (patch) | |
| tree | 57dc34cd1b31064327b094251548e7621190d250 | |
| parent | eb8a05b13256c036f5e18efbdae3a1bc7f26e476 (diff) | |
test changes.sort-balanced-merge-pause
| -rw-r--r-- | src/test/sort/speed.c | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/src/test/sort/speed.c b/src/test/sort/speed.c index 13a86f8bf9..6b8bc65647 100644 --- a/src/test/sort/speed.c +++ b/src/test/sort/speed.c @@ -63,22 +63,31 @@ execute_test(const char *testname, const char *query) static void execute_test_series(char *tblname) { - static const char *work_mems[] = { "1MB", "4MB", "8MB", "16MB", "32MB", "64MB", "128MB", "256MB", "512MB", NULL }; + static const char *work_mems[] = { "64kB", "256kB", "1MB", "4MB", "8MB", "16MB", "32MB", "128MB", "512MB", NULL }; int i; + char sql[100]; printf("# Tests on medium-sized tables (1 GB), different work_mems\n"); printf("-----\n"); + snprintf(sql, sizeof(sql), "set temp_tablespaces='devshm'"); + execute(sql); + snprintf(sql, sizeof(sql), "DROP TABLE IF EXISTS testtab "); + execute(sql); + snprintf(sql, sizeof(sql), "CREATE TEMP TABLE testtab AS SELECT * FROM %s", tblname); + execute(sql); + snprintf(sql, sizeof(sql), "VACUUM ANALYZE testtab "); + execute(sql); + for (i = 0; work_mems[i] != NULL; i++) { const char *work_mem = work_mems[i]; - char sql[100]; char testname[100]; snprintf(sql, sizeof(sql), "set work_mem='%s'", work_mem); execute(sql); snprintf(testname, sizeof(testname), "%s - %s", tblname, work_mem); - snprintf(sql, sizeof(sql), "SELECT COUNT(*) FROM (SELECT * FROM %s ORDER BY 1) t", tblname); + snprintf(sql, sizeof(sql), "SELECT COUNT(*) FROM (SELECT * FROM testtab ORDER BY 1) t"); execute_test(testname, sql); } |