> Then if I reindex my DB I have :
>
> NOTICE: --Relation astro--
> NOTICE: Pages 204: Changed 0, reaped 0, Empty 0, New 0; Tup
> 4878: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 324, MaxLen 324;
> Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU
0.04s/0.18u sec.
> NOTICE: Index astro_pkey: Pages 25; Tuples 4878. CPU 0.01s/0.01u sec.
>
> If I do :
> select * from astro;
>
> I have :
>
...
> (0 rows)
Well, it may be caused by corrupted next_xid in pg_variable.
Could you
CREATE TABLE foo (bar int);
select xmin from pg_class where relname = 'foo';
and say what is exact size of pg_log file?
Vadim
