====== PostgreSQL表及索引存储开销 ======

===== 总览 =====

<code>
行数: 17,000,000
表大小: 2193M
索引: 4401M
------------------------------------
存储空间总计: 6594M
</code>

===== 表结构 =====

<code>
CREATE TABLE tb1
(
  id 	bigserial 	NOT NULL,
  b1 	bigint 		NOT NULL DEFAULT 0,
  b2 	bigint 		NOT NULL DEFAULT 0,
  b3 	bigint 		NOT NULL DEFAULT 0,
  n1 	integer 	NOT NULL DEFAULT 0,
  n2 	integer 	NOT NULL DEFAULT 0,
  s1 	smallint 	NOT NULL DEFAULT 0,
  s2 	smallint 	NOT NULL DEFAULT 0,
  s3 	smallint 	NOT NULL DEFAULT 0,
  s4 	smallint 	NOT NULL DEFAULT 0,
  c1 	character 	arying(250) NOT NULL DEFAULT ''::character varying,
  c2 	character 	arying(250) NOT NULL DEFAULT ''::character varying,
  ctime timestamp without time zone NOT NULL DEFAULT now(),
  mtime timestamp without time zone NOT NULL DEFAULT now(),
  CONSTRAINT id PRIMARY KEY (id) USING INDEX TABLESPACE test_index
)
WITH (OIDS=TRUE);
ALTER TABLE tb1 OWNER TO pgsql;
</code>

===== 索引结构 =====

<code>
索引字段: 	id,b1,b2,b3,n1,n2,s1,s2,s3,s4,ctime,mtime
索引类型: 	B-tree
</code>

===== 典型记录行 =====

====ID: 1200====
<code>
1200, 58978769, 7727542, 
906551, 69004, 
5747, 9788, 
53, 8, 8, 
"4741608", "58746832", 
"2007-10-24 21:42:19.90392", "2007-10-24 21:42:19.90392"
</code>

====ID: 5610000====
<code>
5610000, 6115957, 9779630, 
203488, 66135, 
7421, 997, 
65, 8, 7, 
"3468287", "5315941", 
"2007-10-24 22:55:39.200836", "2007-10-24 22:55:39.200836"
</code>