Measure the servers's IO performance - Mailing list pgsql-hackers

From Andy Fan
Subject Measure the servers's IO performance
Date
Msg-id 87jzg9mk1r.fsf@163.com
Whole thread Raw
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ANALYZE ONLY
Next
From: Michael Harris
Date:
Subject: Re: ANALYZE ONLY