[snaga@devsv03 postgresql.git]$ sh test_recovery.sh
createdb: database creation failed: ERROR:  database "testdb" already exists
drop table if exists t1;
DROP TABLE
create table t1 ( c1 varchar(20) );
CREATE TABLE
checkpoint;
CHECKPOINT
select count(*) from t1;
 count
-------
     0
(1 row)

select relname,relfilenode from pg_class where relname='t1';
 relname | relfilenode
---------+-------------
 t1      |      147456
(1 row)

select oid,* from pg_database where datname=current_database();
  oid  | datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | datminmxid | dattablespace | datacl
-------+---------+--------+----------+------------+----------+---------------+--------------+--------------+---------------+--------------+------------+---------------+--------
 16384 | testdb  |     10 |        0 | C          | C        | f             | t            |           -1 |         12895 |         1799 |          1 |          1663 |
(1 row)

insert into t1 values (trim(to_char(generate_series(1,1000), '00000000000000000000')) );
INSERT 0 1000
select count(*) from t1;
 count
-------
  1000
(1 row)

select pg_relation_size('t1');
 pg_relation_size
------------------
            57344
(1 row)

checkpoint;
CHECKPOINT
insert into t1 values (trim(to_char(generate_series(1001,2000), '00000000000000000000')) );
INSERT 0 1000
select count(*) from t1;
 count
-------
  2000
(1 row)

select pg_relation_size('t1');
 pg_relation_size
------------------
           106496
(1 row)

/tmp/pgsql/data/base/16384/147456
waiting for server to start....2013-07-26 13:33:03 JST [@ 14651] LOG:  loaded library "pg_stat_statements"
 done
server started
2013-07-26 13:33:03 JST [@ 14653] LOG:  database system was interrupted; last known up at 2013-07-26 13:33:03 JST
2013-07-26 13:33:03 JST [@ 14653] LOG:  database system was not properly shut down; automatic recovery in progress
2013-07-26 13:33:03 JST [@ 14653] LOG:  redo starts at 0/1D493A0
2013-07-26 13:33:03 JST [@ 14653] LOG:  record with zero length at 0/1D5D958
2013-07-26 13:33:03 JST [@ 14653] LOG:  redo done at 0/1D5D928
2013-07-26 13:33:03 JST [@ 14653] LOG:  last completed transaction was at log time 2013-07-26 13:33:03.158161+09
2013-07-26 13:33:03 JST [@ 14651] LOG:  database system is ready to accept connections
2013-07-26 13:33:03 JST [@ 14657] LOG:  autovacuum launcher started
select count(*) from t1;
 count
-------
  1058
(1 row)

select pg_relation_size('t1');
 pg_relation_size
------------------
           106496
(1 row)

createdb: database creation failed: ERROR:  database "testdb" already exists
drop table if exists t1;
DROP TABLE
create table t1 ( c1 varchar(20) );
CREATE TABLE
checkpoint;
CHECKPOINT
select count(*) from t1;
 count
-------
     0
(1 row)

select relname,relfilenode from pg_class where relname='t1';
 relname | relfilenode
---------+-------------
 t1      |      155648
(1 row)

select oid,* from pg_database where datname=current_database();
  oid  | datname | datdba | encoding | datcollate | datctype | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | datminmxid | dattablespace | datacl
-------+---------+--------+----------+------------+----------+---------------+--------------+--------------+---------------+--------------+------------+---------------+--------
 16384 | testdb  |     10 |        0 | C          | C        | f             | t            |           -1 |         12895 |         1799 |          1 |          1663 |
(1 row)

insert into t1 values (trim(to_char(generate_series(1,1000), '00000000000000000000')) );
INSERT 0 1000
select count(*) from t1;
 count
-------
  1000
(1 row)

select pg_relation_size('t1');
 pg_relation_size
------------------
            57344
(1 row)

checkpoint;
CHECKPOINT
insert into t1 values (trim(to_char(generate_series(1001,2000), '00000000000000000000')) );
INSERT 0 1000
select count(*) from t1;
 count
-------
  2000
(1 row)

select pg_relation_size('t1');
 pg_relation_size
------------------
           106496
(1 row)

/tmp/pgsql/data/base/16384/155648
waiting for server to start....2013-07-26 13:33:05 JST [@ 14677] LOG:  loaded library "pg_stat_statements"
 done
server started
2013-07-26 13:33:05 JST [@ 14679] LOG:  database system was interrupted; last known up at 2013-07-26 13:33:04 JST
2013-07-26 13:33:05 JST [@ 14679] LOG:  database system was not properly shut down; automatic recovery in progress
2013-07-26 13:33:05 JST [@ 14679] LOG:  redo starts at 0/1D847F0
2013-07-26 13:33:05 JST [@ 14679] LOG:  record with zero length at 0/1D98DA8
2013-07-26 13:33:05 JST [@ 14679] LOG:  redo done at 0/1D98D78
2013-07-26 13:33:05 JST [@ 14679] LOG:  last completed transaction was at log time 2013-07-26 13:33:04.936051+09
2013-07-26 13:33:05 JST [@ 14677] LOG:  database system is ready to accept connections
2013-07-26 13:33:05 JST [@ 14683] LOG:  autovacuum launcher started
select count(*) from t1;
 count
-------
  1058
(1 row)

select pg_relation_size('t1');
 pg_relation_size
------------------
           106496
(1 row)

[snaga@devsv03 postgresql.git]$