PostgreSQL High Availability Cookbook - Second Edition

How to do it...

Follow these steps if possible:

1. Request a LUN from the infrastructure department with the necessary IOPS and storage requirements.
2. If a SAN isn't available, many SAN vendors will provide testing equipment to encourage purchase. Try to obtain one of these.
3. Have the infrastructure department format the allocation and attach it to a testing server. Keep note of the path to the storage.
4. Create a basic PostgreSQL testing database with the following command-line operations as the postgres user:

        createdb pgbench 
        pgbench -i -s 4000 pgbench 

5. Drop the system caches as a user capable of performing root-level commands, as follows:

        echo 3 | sudo tee /proc/sys/vm/drop_caches 

6. Test the storage read IOPS with one final command as ...