Re: BUG #5599: Vacuum fails due to index corruption issues - Mailing list pgsql-bugs

From Hitesh Bhambhani
Subject Re: BUG #5599: Vacuum fails due to index corruption issues
Date
Msg-id 8B7319E089E48047A0B688CE9CF54FD855C3C90D@USRES8MAIL.asg.com
Whole thread Raw
In response to Re: BUG #5599: Vacuum fails due to index corruption issues  (Greg Stark <gsstark@mit.edu>)
Responses Re: BUG #5599: Vacuum fails due to index corruption issues
List pgsql-bugs
Greg, thanks for your answers.

My comments below...

> From: gsstark@gmail.com [mailto:gsstark@gmail.com] On Behalf Of Greg Stark
> Sent: Wednesday, August 04, 2010 9:35 PM
> Firstly, the current release of 8.2 is 8.2.17. There are a long list of b=
ugs
> fixed in those intervening releases including one involving vacuum trunca=
ting
> relations. I don't think it's the same problem but I would recommend upda=
ting
> immediately to 8.2.17.
>=20
[HiteshB] I have noted your recommendation and will work with our Product M=
anagement to upgrade to the latest and greatest. Although we can't change t=
he version that the customer has installed (8.2.9-1).

>=20
>=20
> Secondly we don't recommend running VACUUM FULL routinely. It should only=
 be
> necessary in extraordinary circumstances. Normally a plain VACUUM (or VAC=
UUM
> ANALYZE or VACUUM VERBOSE) should be sufficient as long as it's being run
> regularly. Regular VACUUM without the "FULL"
> has much less impact on the system.
>=20
[HiteshB] Point noted. The decision to use VACUUM FULL is something we'll r=
e-examine.
Could you give an example of what an 'extraordinary circumstance' would be?

>=20
> "Permission denied" smells like a Windows problem with concurrent file
> operations. Are you sure you're not running any anti-virus software or ba=
ckup
> software which could have these files open and prevent Postgres from
> performing regular file operations on its files? Many people have reported
> other problems with anti-virus software in particular.
>=20
[HiteshB] We have worked with the customer to exclude the postgre directory=
 from their antivirus scans. Hopefully we won't see this Permission issue a=
gain.

Thanks again.
Regards,
Hitesh

pgsql-bugs by date:

Previous
From: Hitesh Bhambhani
Date:
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5599: Vacuum fails due to index corruption issues