[GENERAL] How to evaluate disk space needed by a table

Hello: I created a table, and found the file created for that table is about 10 times of that I estimated! The following is what I did: postgres=# create table tst01(id integer); CREATE TABLE postgres=# postgres=# select oid from pg_class where relname='tst01'; oid --- 16384 (1 row)

Re: [GENERAL] How to evaluate disk space needed by a table

* 高健 (luckyjack...@gmail.com) wrote: So , Is there any method to correctly evaluate disk space one table will need, given the table's column data types and , estimated record numbers ? The simplest might be to do exactly what you did- create the table and then check the size with a subset of

Re: [GENERAL] How to evaluate disk space needed by a table

On Tue, May 28, 2013 at 9:48 AM, 高健 luckyjack...@gmail.com wrote: Hello: I created a table, and found the file created for that table is about 10 times of that I estimated! The following is what I did: postgres=# create table tst01(id integer); CREATE TABLE postgres=# postgres=#