Re: Vacuum full? - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: Vacuum full?
Date
Msg-id 3DCADE4C.7090007@openratings.com
Whole thread Raw
In response to Vacuum full?  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: Vacuum full?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks, Tom!

By closing other transactions, did you mean ALL transactions open in
that database, or just the ones, having anything to do with that table
(reading/writing)?

Thanks again!

Dima

Tom Lane wrote:

>Dmitry Tkach <dmitry@openratings.com> writes:
>
>>ERROR:  No one parent tuple was found
>>
>
>Closing out other open transactions will probably make that go away.
>You should also consider updating to 7.2.3, if you're not there already.
>(IIRC, there is a partial fix in 7.2.3.  7.3 will fix all the causes we
>know about.)
>
>            regards, tom lane
>




pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: request new feature: auto recompile of function when oid not found
Next
From: CSN
Date:
Subject: Database design software