This is a multi-part message in MIME format.
------_=_NextPart_001_01CA1CF8.EEE11446
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Postgresql 8.2
When I do a full vacuum of our database I get the following:
NOTICE: relation "pg_class" TID 23/39: DeleteTransactionInProgress
4060299835 --- can't shrink relation
NOTICE: relation "pg_class" TID 31/31: InsertTransactionInProgress
4060299835 --- can't shrink relation VACUUM
What does this mean?
Thanks,
Lance Campbell
Project Manager/Software Architect/DBA
Web Services at Public Affairs
217-333-0382
------_=_NextPart_001_01CA1CF8.EEE11446
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7654.12">
<TITLE>Vacuum Issue 8.2</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Postgresql 8.2</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">When I do a full vacuum of our database =
I get the following:</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">NOTICE: relation =
"pg_class" TID 23/39: DeleteTransactionInProgress 4060299835 =
--- can't shrink relation</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">NOTICE: relation =
"pg_class" TID 31/31: InsertTransactionInProgress 4060299835 =
--- can't shrink relation VACUUM</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">What does this mean?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Lance Campbell</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Project Manager/Software =
Architect/DBA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Web Services at Public Affairs</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">217-333-0382</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01CA1CF8.EEE11446--
