From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
---|---|
To: | "'Jean-Arthur Silve'" <jeanarthur(at)eurovox(dot)fr>, pgsql-admin(at)postgresql(dot)org |
Subject: | RE: SOS !!: Porstgress forgot all ! Help ! |
Date: | 2001-02-12 16:41:02 |
Message-ID: | 8F4C99C66D04D4118F580090272A7A234D32E6@sectorbase1.sectorbase.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | G. Anthony Reina | 2001-02-12 17:30:05 | Dual processors for Postgres? |
Previous Message | Jean-Arthur Silve | 2001-02-12 16:20:45 | RE: SOS !!: Porstgress forgot all ! Help ! |