Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [GENERAL] Need Help
- From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
- To: JM <jerome(at)gmanmi(dot)tv>, pgsql-general(at)postgresql(dot)org
- Cc: "Pgsql-Performance \(E-mail\)" <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: [GENERAL] Need Help
- Date: Wed, 27 Dec 2006 18:54:44 -0800 (PST)
--- JM <jerome(at)gmanmi(dot)tv> wrote: > how can i get the disk usage for each table? can i do it via SQL? This function should do what you want: pg_relation_size(text) or pg_total_relation_size(text) I found it on the following link: http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE Regards, Richard Broersma Jr.
- References:
- Need Help
- From: JM
- Need Help
- Prev by Date: Need Help
- Next by Date: High update activity, PostgreSQL vs BigDBMS
- Previous by thread: Need Help
- Next by thread: High update activity, PostgreSQL vs BigDBMS
- Indexes: