Hi,
pgsql 8.3.7 and 8.4.0
when i issue an "immediate shutdown" the statistics on all tables disappear...
and when i try to recover them via an analyze; (on all tables on the
database) the result is nothing...
i have to exexute the analyze commands twice to compute the statistics
jd=# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname = 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 111 | 0
(1 row)
jd=# select version();
version
----------------------------------------------------------------------------------------------------
PostgreSQL 8.4.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(Debian 4.3.2-1.1) 4.3.2, 64-bit
(1 row)
jd=# \q
postg...@casanova1:/usr/local/pgsql/8.4$ bin/pg_ctl -m immediate -D
$PWD/data stop
waiting for server to shut down.... done
server stopped
postg...@casanova1:/usr/local/pgsql/8.4$ bin/pg_ctl -D $PWD/data start
server starting
postg...@casanova1:/usr/local/pgsql/8.4$ bin/psql
psql (8.4.0)
Type "help" for help.
jd=# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname = 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 0 | 0
(1 row)
jd=# analyze;
ANALYZE
jd=# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname = 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 0 | 0
(1 row)
jd=# analyze;
ANALYZE
jd=# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname = 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 111 | 0
(1 row)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
AsesorÃa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
