RE: SOS !!: Porstgress forgot all ! Help ! - Mailing list pgsql-admin

From Mikheev, Vadim
Subject RE: SOS !!: Porstgress forgot all ! Help !
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D32E6@sectorbase1.sectorbase.com
Whole thread Raw
In response to SOS !!: Porstgress forgot all ! Help !  (Jean-Arthur Silve <jeanarthur@eurovox.fr>)
List pgsql-admin
> I tried, but nothing has changed !
>
> The strangest is I have a database which was not accessed
> sinc several days and even this one does not function....
>
> in pg_class, I see for exemple that one on my table has
> ntuples=1800 but I can't access it...

Oh, so you're able to select from your table but select
returns 0 tuples?
Ok, what exactly vacuum verbose says about your table with
1800 tuples (vacuum' message asis, please).
I saw something like this when pg_variables was corrupted
and table' tuples weren't visible because of next_xid
was too small but I need in vacuum message to know
is it that case or not.

Vadim

pgsql-admin by date:

Previous
From: Jean-Arthur Silve
Date:
Subject: RE: SOS !!: Porstgress forgot all ! Help !
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: SOS !!: Porstgress forgot all ! Help !