Re: possible data loss.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mallah(at)trade-india(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: possible data loss.
Date: 2003-06-08 15:34:42
Message-ID: 29503.1055086482@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<mallah(at)trade-india(dot)com> writes:
> I did an vacuum full on a particular table of
> pgsql 7.2.3 database as a non superuser.
> and i feel i have lost considerable data in this
> text feild in this table. I think it was a known bug with
> this version.

The vacuum output shows 91902 live tuples during the first vacuum,
and 91906 during the second. What is the basis of your assertion
that you've lost data?

It does appear that some other operation updated most of the rows in
the table in between, since the second vacuum found 82457 dead tuples.
I'm suspecting that your real problem is an ill-considered update.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-06-08 15:50:52 Re: Problem with tcp/ip connection, postgresql.conf
Previous Message Tom Lane 2003-06-08 15:24:25 Re: Uninitialized page - fixing