Re: Discussion: Fast DB/Schema/Table disk size check in Postgresql

2019-01-05 Thread Stephen Frost
Greetings, * Hubert Zhang (hzh...@pivotal.io) wrote: > For very large databases, the dbsize function `pg_database_size_name()` > etc. could be quite slow, since it needs to call `stat()` system call on > every file in the target database. I agree, it'd be nice to improve this. > We proposed a

Discussion: Fast DB/Schema/Table disk size check in Postgresql

2018-12-17 Thread Hubert Zhang
Hi all, For very large databases, the dbsize function `pg_database_size_name()` etc. could be quite slow, since it needs to call `stat()` system call on every file in the target database. We proposed a new solution to accelerate these dbsize functions which check the disk usage of