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=3D# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname =3D 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 111 | 0
(1 row)
jd=3D# 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=3D# \q
postgres@casanova1:/usr/local/pgsql/8.4$ bin/pg_ctl -m immediate -D
$PWD/data stop
waiting for server to shut down.... done
server stopped
postgres@casanova1:/usr/local/pgsql/8.4$ bin/pg_ctl -D $PWD/data start
server starting
postgres@casanova1:/usr/local/pgsql/8.4$ bin/psql
psql (8.4.0)
Type "help" for help.
jd=3D# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname =3D 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 0 | 0
(1 row)
jd=3D# analyze;
ANALYZE
jd=3D# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname =3D 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 0 | 0
(1 row)
jd=3D# analyze;
ANALYZE
jd=3D# select relname, n_live_tup, n_dead_tup from pg_stat_user_tables
where relname =3D 'bpprovee';
relname | n_live_tup | n_dead_tup
----------+------------+------------
bpprovee | 111 | 0
(1 row)
--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157