delta/postgresql.git/contrib/dbsize, branch master

Move dbsize functions into the backend. New functions:

2005-07-29T14:47:04+00:00

	pg_tablespace_size
	pg_database_size
	pg_relation_size
	pg_complete_relation_size
	pg_size_pretty

Remove /contrib/dbsize.

Dave Page

Arrange for the postmaster (and standalone backends, initdb, etc) to

2005-07-04T04:51:52+00:00

chdir into PGDATA and subsequently use relative paths instead of absolute
paths to access all files under PGDATA.  This seems to give a small
performance improvement, and it should make the system more robust
against naive DBAs doing things like moving a database directory that
has a live postmaster in it.  Per recent discussion.

Simplify uses of readdir() by creating a function ReadDir() that

2005-06-19T21:34:03+00:00

includes error checking and an appropriate ereport(ERROR) message.
This gets rid of rather tedious and error-prone manipulation of errno,
as well as a Windows-specific bug workaround, at more than a dozen
call sites.  After an idea in a recent patch by Heikki Linnakangas.

Remove second argument from textToQualifiedNameList(), as it is no longer

2005-05-27T00:57:49+00:00

used. From Jaime Casanova.

Add routines to dbsize to return the index size and total relation size.

2005-02-26T23:31:15+00:00

Improve documentation.

Ed L.

Update copyrights that were missed.

2005-01-01T05:43:09+00:00

Code review for recent dbsize changes. Fix some thinkos, enforce coding

2004-09-28T19:35:43+00:00

style and message style standards, improve documentation.

Improve README with mention of new functions.

2004-09-08T19:35:33+00:00

Remove line specifying Andreas as author.

2004-09-02T04:04:04+00:00

The current implementation of dbsize doesn't handle tables in

2004-09-02T00:55:22+00:00

tablespaces correctly, and is quite restricted on objects covered (only
tables and databases, but not tablespaces and indexes).

The attached patch contributes:

- database_size(name)
- relation_size(text)
These are the well-known functions, tablespace-aware.

- pg_tablespace_size(oid)
- pg_database_size(oid)
- pg_relation_size(oid)
Tablespace-aware implementations, used by the upper functions.
pg_relation_size will report sizes of indexes as well.

- pg_size_pretty(bigint)
Formatting of sizes, to display '146MB' instead of '152885668'

Andreas Pflug