Articles related to technology, how to use software, ways to work around technology problems, install hardware, install software, upgraded software, etc.

Technology Insights

How to Test Disk Input and Output on Linux

There are a couple useful utilities on Linux to test disk input/ouput. Sequential Disk Access: hdparm The hdparm command will test sequential disk access and can be used with the below command. Replace /dev/sda1 with the mounted disk you would like to test such as /dev/hda1. bash hdparm -t /dev/sda1 The results will output similar…

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>…