Thread: database and table information collect
Dear Support Team,
How can we know each table of database information as listed as below?
Maximum Database Size
Maximum Table Size
Maximum Row Size
Maximum Field Size
Maximum Rows per Table
Maximum Columns per Table
Maximum Indexes per Table
Thank you.
On Tue, Oct 20, 2015 at 07:07:32AM +0800, 許èå½° wrote: > Dear Support Team, > How can we know each table of database information as listed as below? > > > Maximum Database Size > > Maximum Table Size > > Maximum Row Size > > Maximum Field Size > > Maximum Rows per Table > > Maximum Columns per Table > > Maximum Indexes per Table See this: https://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Roman grave inscription +
Dear Bruce,
How do we know our database situation as listed as below: (How many size of each table used condition? ) Thank you.
> Maximum Database Size
>
> Maximum Table Size
>
> Maximum Row Size
>
> Maximum Field Size
>
> Maximum Rows per Table
>
> Maximum Columns per Table
>
> Maximum Indexes per Table
>
> Maximum Table Size
>
> Maximum Row Size
>
> Maximum Field Size
>
> Maximum Rows per Table
>
> Maximum Columns per Table
>
> Maximum Indexes per Table
2015-10-20 10:07 GMT+08:00 Bruce Momjian <bruce@momjian.us>:
On Tue, Oct 20, 2015 at 07:07:32AM +0800, 許耀彰 wrote:
> Dear Support Team,
> How can we know each table of database information as listed as below?
>
>
> Maximum Database Size
>
> Maximum Table Size
>
> Maximum Row Size
>
> Maximum Field Size
>
> Maximum Rows per Table
>
> Maximum Columns per Table
>
> Maximum Indexes per Table
See this:
https://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +
On 10/19/2015 9:30 PM, 許èå½° wrote: > Dear Bruce, > How do we know our database situation as listed as below: (How many > size of each table used condition? ) Thank you. these questions would better be asked of the pg_general email list, and not the bug reporting mail list, as they are not bug reports. that said, this was answered when you asked it 3 days ago... there's a series of functions like pg_relation_size(), pg_total_relation_size() which will give you the size of a specific table. these are all documented here, http://www.postgresql.org/docs/current/static/functions-admin.html if you want the size of every table, then you could do something like... select table_schema || '.' || table_name, pg_size_pretty(pg_total_relation_size(table_schema||'.'||table_name)) from informa tion_schema.tables where table_schema not in ('pg_catalog', 'information_schema') order by pg_total_relation_size(table_schema||'.'| |table_name) desc; -- john r pierce, recycling bits in santa cruz