| 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: | Whole Thread | Raw Message | 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 ! |