Remove CHECKPOINT call from pgbench -- Not needed and affects performance.

bmomjian · bmomjian · commit c9361a7a9c47 · 2002-02-18T05:46:41.000Z
diff --git a/contrib/pgbench/pgbench.c b/contrib/pgbench/pgbench.c
@@ -1,5 +1,5 @@
 /*
- * $Header: /cvsroot/pgsql/contrib/pgbench/pgbench.c,v 1.14 2002/01/10 01:11:45 tgl Exp $
+ * $Header: /cvsroot/pgsql/contrib/pgbench/pgbench.c,v 1.15 2002/02/18 05:46:41 momjian Exp $
  *
  * pgbench: a simple TPC-B like benchmark program for PostgreSQL
  * written by Tatsuo Ishii
@@ -548,16 +548,6 @@ init()
 				fprintf(stderr, "PQendcopy failed\n");
 				exit(1);
 			}
-
-			/*
-			 * do a checkpoint to purge the old WAL logs
-			 */
-			res = PQexec(con, "checkpoint");
-			if (PQresultStatus(res) != PGRES_COMMAND_OK)
-			{
-				fprintf(stderr, "%s", PQerrorMessage(con));
-				exit(1);
-			}
 		}
 	}
 

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`/*`
`2`		`- * $Header: /cvsroot/pgsql/contrib/pgbench/pgbench.c,v 1.14 2002/01/10 01:11:45 tgl Exp $`
	`2`	`+ * $Header: /cvsroot/pgsql/contrib/pgbench/pgbench.c,v 1.15 2002/02/18 05:46:41 momjian Exp $`
`3`	`3`	`*`
`4`	`4`	`* pgbench: a simple TPC-B like benchmark program for PostgreSQL`
`5`	`5`	`* written by Tatsuo Ishii`
`@@ -548,16 +548,6 @@ init()`
`548`	`548`	`fprintf(stderr, "PQendcopy failed\n");`
`549`	`549`	`exit(1);`
`550`	`550`	`}`
`551`		`-`
`552`		`- /*`
`553`		`- * do a checkpoint to purge the old WAL logs`
`554`		`- */`
`555`		`- res = PQexec(con, "checkpoint");`
`556`		`- if (PQresultStatus(res) != PGRES_COMMAND_OK)`
`557`		`- {`
`558`		`- fprintf(stderr, "%s", PQerrorMessage(con));`
`559`		`- exit(1);`
`560`		`- }`
`561`	`551`	`}`
`562`	`552`	`}`
`563`	`553`