Thread: Measure the servers's IO performance

Measure the servers's IO performance

From
Andy Fan
Date:
Hello,

Sometimes user want to measure the server's IO performance during some
troubleshooting *without* the access to postgresql server. Is there any
good way to measure it in such sistuation?

Measuring it with SELECT .. FROM t WHERE xxx, both shared_buffer in PG
and file system buffer bothers. pg_read_binary_file is better, but file
system cache still there. should we expose a direct-io option for
pg_read_binary_file? 

-- 
Best Regards
Andy Fan