BUG #6267: Wrong results in pg_database_size
От | Maksym Boguk |
---|---|
Тема | BUG #6267: Wrong results in pg_database_size |
Дата | |
Msg-id | 201110250858.p9P8wjcQ085632@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #6267: Wrong results in pg_database_size
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 6267 Logged by: Maksym Boguk Email address: maxim.boguk@gmail.com PostgreSQL version: 9.0.4 Operating system: Linux 2.6.32-5 Description: Wrong results in pg_database_size Details: Somehow pg_database_size producing results which are 2Ñ more then reality. Here is details: postgres=# SELECT oid,datname,dattablespace,pg_size_pretty(pg_database_size(datname)) from pg_database where datname IN ('plus1', 'stinger_3'); oid | datname | dattablespace | pg_size_pretty -------+-----------+---------------+---------------- 16453 | plus1 | 16443 | 103 GB 16458 | stinger_3 | 16443 | 114 GB In reality they are 2x smaller: postgres@shalyapin:/home/mboguk$ du --max-depth=1 -h /db/base/main/PG_9.0_201008051/16453 52G /db/base/main/PG_9.0_201008051/16453 postgres@shalyapin:/home/mboguk$ du --max-depth=1 -h /db/base/main/PG_9.0_201008051/16458 58G /db/base/main/PG_9.0_201008051/16458 pg_tablespace_size producing correct results postgres=# SELECT oid,spcname,spclocation,pg_size_pretty(pg_tablespace_size(spcname)) from pg_tablespace; oid | spcname | spclocation | pg_size_pretty -------+------------+---------------+---------------- 1663 | pg_default | | 21 MB 1664 | pg_global | | 1092 kB 16443 | main | /db/base/main | 124 GB May be database located outside of the pg_default get his size calculated twice (now sure how). All other databases on that cluster have same wronge results about database size including template0/template1 databases.
В списке pgsql-bugs по дате отправления: