Technology Insights

Delete All Rows from a PostgreSQL Table

Use the truncate command from the CLI or via PGAdmin to delete all rows from a PostgreSQL database. To use PGAdmin follow the directions here or follow the directions below to truncate the table from the CLI. Connect: Connect to PostgreSQL with psql. Delete Rows: Type the following from the CLI. bash dev=# truncate table <em>table_name</em>…

Technology Insights

What does pgbench TPS stand for?

When pgbench results are provided they are shown as TPS or transactions per second. Below is an example of pgbench being used. bash bash-3.1$ pgbench -Upostgres -s 10 -c 10 -t 3000 pgbench starting vacuum…end. transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 10 number of transactions per client: 3000 number of…