Thanks Stephen.
>
> In the largest portion of the system, when it comes to tables, indexes,
> and such, if there's a file 'X.1', you can be pretty darn sure that 'X'
> is 1GB in size. If there's a file 'X.245' then you can know that
> there's 245 files (X, X.1, X.2, X.3 ... X.244) that are 1GB in
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 ne
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 database/schema
