Measure the servers's IO performance

From: Andy Fan <zhihuifan1213(at)163(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Measure the servers's IO performance
Date: 2024-08-22 01:18:56
Message-ID: 87jzg9mk1r.fsf@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Harris 2024-08-22 01:37:52 Re: ANALYZE ONLY
Previous Message Tom Lane 2024-08-22 01:12:16 Re: ANALYZE ONLY