pgsql: Add pg_stat_io view, providing more detailed IO statistics

2023-02-11 Thread Andres Freund
Add pg_stat_io view, providing more detailed IO statistics Builds on 28e626bde00 and f30d62c2fc6. See the former for motivation. Rows of the view show IO operations for a particular backend type, IO target object, IO context combination (e.g. a client backend's operations on permanent relations i

pgsql: Add tests for pg_stat_io

2023-02-11 Thread Andres Freund
Add tests for pg_stat_io Author: Melanie Plageman Reviewed-by: Andres Freund Reviewed-by: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/10a082bf72150f49c34fcf152565

pgsql: Create regress_tblspc in test_setup

2023-02-11 Thread Andres Freund
Create regress_tblspc in test_setup An upcoming test needs to use a tablespace as part of its test. Historically, we wanted tablespace creation be done in a dedicated file, so it's easy to disable when testing replication. But that is not necessary anymore, due to allow_in_place_tablespaces. Crea