Re: Table size
От
Michael Fuhr
Тема
Re: Table size
Дата
Msg-id
20070614131621.GA70209@winnie.fuhr.org
Ответ на
Table size (Shyam Sunder Rai)
Список
Дерево обсуждения
Table size "Shyam Sunder Rai" <ssrai@ismartpanache.com>
Re: Table size Michael Fuhr <mike@fuhr.org>
Re: Table size Jim Nasby <decibel@decibel.org>
Re: Table size Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote: > How can I calculate a table size in postgres ? To find the size of an existing table use pg_relation_size() or pg_total_relation_size() (8.1 and later; in earlier versions use the functions in contrib/dbsize). http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE Or did you want to estimate the size of a table given the number and types of its columns and the number of rows? -- Michael Fuhr
В списке pgsql-admin по дате отправления
