This is a multi-part message in MIME format.
------_=_NextPart_001_01CA7CF4.9CE1A6F2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Strange - seems to have sorted itself out.
I turned off a scheduled vacuum of the table and within a few minutes I
sorted itself out.
I have reduced the frequency of the vacuuming task which is being
carried out via pgagent.
From: Benjamin Krajmalnik
Sent: Monday, December 14, 2009 12:28 PM
To: Benjamin Krajmalnik; 'pgsql-admin [at] postgresql.org'
Subject: RE: Error when clustering a table
Additional info:
When I perform a vacuum full, this is the information I am getting:
INFO: vacuuming "public.tblksaura"
INFO: "tblksaura": found 89 removable, 238907 nonremovable row versions
in 59808 pages
DETAIL: 200792 dead row versions cannot be removed yet.
Nonremovable row versions range from 1776 to 2032 bytes long.
There were 391587 unused item pointers.
Total free space (including removable row versions) is 19992676 bytes.
3 pages are or will become empty, including 0 at the end of the table.
616 pages containing 945300 free bytes are potential move destinations.
CPU 0.00s/0.22u sec elapsed 0.23 sec.
INFO: index "tblksaura_kstestssysid_key" now contains 58562 row
versions in 211 pages
DETAIL: 13 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.01 sec.
WARNING: index "tblksaura_kstestssysid_key" contains 58562 row
versions, but table contains 229083 row versions
HINT: Rebuild the index with REINDEX.
INFO: index "tblksaura_pkey" now contains 58562 row versions in 211
pages
DETAIL: 13 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.01 sec.
WARNING: index "tblksaura_pkey" contains 58562 row versions, but table
contains 229083 row versions
HINT: Rebuild the index with REINDEX.
INFO: index "tblksaura_idx_time" now contains 58562 row versions in 183
pages
DETAIL: 13 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.01 sec.
WARNING: index "tblksaura_idx_time" contains 58562 row versions, but
table contains 229083 row versions
HINT: Rebuild the index with REINDEX.
INFO: index "tblksaura_idx_kstestssysid" now contains 58562 row
versions in 298 pages
DETAIL: 13 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.01 sec.
WARNING: index "tblksaura_idx_kstestssysid" contains 58562 row
versions, but table contains 229083 row versions
HINT: Rebuild the index with REINDEX.INFO: "tblksaura": moved 168 row
versions, truncated 59808 to 59803 pages
DETAIL: CPU 0.00s/0.13u sec elapsed 0.13 sec.INFO: index
"tblksaura_kstestssysid_key" now contains 58714 row versions in 212
pages
DETAIL: 16 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
WARNING: index "tblksaura_kstestssysid_key" contains 58714 row
versions, but table contains 229235 row versions
HINT: Rebuild the index with REINDEX.
INFO: index "tblksaura_pkey" now contains 58714 row versions in 212
pages
DETAIL: 16 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
WARNING: index "tblksaura_pkey" contains 58714 row versions, but table
contains 229235 row versions
HINT: Rebuild the index with REINDEX.
INFO: index "tblksaura_idx_time" now contains 58714 row versions in 183
pages
DETAIL: 16 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
WARNING: index "tblksaura_idx_time" contains 58714 row versions, but
table contains 229235 row versions
HINT: Rebuild the index with REINDEX.
INFO: index "tblksaura_idx_kstestssysid" now contains 58714 row
versions in 299 pages
DETAIL: 16 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
WARNING: index "tblksaura_idx_kstestssysid" contains 58714 row
versions, but table contains 229235 row versions
HINT: Rebuild the index with REINDEX.INFO: vacuuming
"pg_toast.pg_toast_145099"INFO: "pg_toast_145099": found 245 removable,
117973 nonremovable row versions in 4479 pages
DETAIL: 101666 dead row versions cannot be removed yet.
Nonremovable row versions range from 178 to 312 bytes long.
There were 31907 unused item pointers.
Total free space (including removable row versions) is 726932 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1411 pages containing 481984 free bytes are potential move destinations.
CPU 0.00s/0.02u sec elapsed 0.02 sec.INFO: index
"pg_toast_145099_index" now contains 117973 row versions in 342 pages
DETAIL: 245 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.01 sec.INFO: "pg_toast_145099": moved 495
row versions, truncated 4479 to 4457 pages
DETAIL: CPU 0.00s/0.02u sec elapsed 0.02 sec.
INFO: index "pg_toast_145099_index" now contains 117973 row versions in
343 pages
DETAIL: 495 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.Total query runtime: 719 ms.
What can be causing such a high number of rows to be nonremovable?
From: Benjamin Krajmalnik
Sent: Monday, December 14, 2009 12:17 PM
To: pgsql-admin [at] postgresql.org
Subject: Error when clustering a table
I am trying to cluster a table for which vacuum full is not reducing its
size.
When I do so, I am getting the following error:
ERROR: missing chunk number 0 for toast value 207869115 in
pg_toast_145099
********** Error **********
ERROR: missing chunk number 0 for toast value 207869115 in
pg_toast_145099
SQL state: XX000
Any idea how this can be remediated?
------_=_NextPart_001_01CA7CF4.9CE1A6F2
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Strange – seems =
to have sorted
itself out.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>I turned off a =
scheduled vacuum
of the table and within a few minutes I sorted itself =
out.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>I have reduced the =
frequency of
the vacuuming task which is being carried out via =
pgagent.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in =
0in 4.0pt'>
<div>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' > Benjamin =
Krajmalnik
<br>
<b>Sent:</b> Monday, December 14, 2009 12:28 PM<br>
<b>To:</b> Benjamin Krajmalnik; 'pgsql-admin [at] postgresql.org'<br>
<b>Subject:</b> RE: Error when clustering a table<o:p></o:p></span></p>
</div>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Additional =
info:<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>When I perform a =
vacuum full,
this is the information I am getting:<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: vacuuming =
"public.tblksaura"<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO:
"tblksaura": found 89 removable, 238907 nonremovable row =
versions in
59808 pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 200792 =
dead row
versions cannot be removed yet.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Nonremovable row =
versions range
from 1776 to 2032 bytes long.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>There were 391587 =
unused item pointers.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Total free space =
(including
removable row versions) is 19992676 bytes.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>3 pages are or will =
become
empty, including 0 at the end of the table.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>616 pages containing =
945300 free
bytes are potential move destinations.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.22u sec =
elapsed 0.23
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_kstestssysid_key" now contains 58562 row versions =
in 211
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 13 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.01u sec =
elapsed 0.01
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index =
"tblksaura_kstestssysid_key"
contains 58562 row versions, but table contains 229083 row =
versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_pkey" now contains 58562 row versions in 211 =
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 13 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.01u sec =
elapsed 0.01
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_pkey" contains 58562 row versions, but table =
contains
229083 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_idx_time" now contains 58562 row versions in 183 =
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 13 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.01u sec =
elapsed 0.01
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_idx_time" contains 58562 row versions, but table =
contains
229083 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_idx_kstestssysid" now contains 58562 row versions =
in 298
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 13 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.01u sec =
elapsed 0.01
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_idx_kstestssysid" contains 58562 row versions, but =
table
contains 229083 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.INFO: "tblksaura": moved 168 row versions, =
truncated
59808 to 59803 pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: CPU =
0.00s/0.13u
sec elapsed 0.13 sec.INFO: index =
"tblksaura_kstestssysid_key"
now contains 58714 row versions in 212 pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 16 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.00u sec =
elapsed 0.00
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_kstestssysid_key" contains 58714 row versions, but =
table
contains 229235 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_pkey" now contains 58714 row versions in 212 =
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 16 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.00u sec =
elapsed 0.00
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_pkey" contains 58714 row versions, but table =
contains
229235 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_idx_time" now contains 58714 row versions in 183 =
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 16 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.00u sec =
elapsed 0.00
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_idx_time" contains 58714 row versions, but table =
contains
229235 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"tblksaura_idx_kstestssysid" now contains 58714 row versions =
in 299
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 16 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.00u sec =
elapsed 0.00
sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>WARNING: index
"tblksaura_idx_kstestssysid" contains 58714 row versions, but =
table
contains 229235 row versions<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>HINT: Rebuild =
the index
with REINDEX.INFO: vacuuming
"pg_toast.pg_toast_145099"INFO: =
"pg_toast_145099":
found 245 removable, 117973 nonremovable row versions in 4479 =
pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 101666 =
dead row
versions cannot be removed yet.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Nonremovable row =
versions range
from 178 to 312 bytes long.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>There were 31907 =
unused item
pointers.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Total free space =
(including
removable row versions) is 726932 bytes.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 pages are or will =
become
empty, including 0 at the end of the table.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>1411 pages containing =
481984
free bytes are potential move destinations.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.02u sec =
elapsed 0.02
sec.INFO: index "pg_toast_145099_index" now contains =
117973 row
versions in 342 pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 245 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.01u sec =
elapsed 0.01
sec.INFO: "pg_toast_145099": moved 495 row versions, =
truncated
4479 to 4457 pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: CPU =
0.00s/0.02u
sec elapsed 0.02 sec.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>INFO: index
"pg_toast_145099_index" now contains 117973 row versions in =
343 pages<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>DETAIL: 495 =
index row
versions were removed.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>0 index pages have =
been deleted,
0 are currently reusable.<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>CPU 0.00s/0.00u sec =
elapsed 0.00
sec.Total query runtime: 719 ms.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>What can be causing =
such a high
number of rows to be nonremovable?<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in =
0in 4.0pt'>
<div>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' > Benjamin =
Krajmalnik
<br>
<b>Sent:</b> Monday, December 14, 2009 12:17 PM<br>
<b>To:</b> pgsql-admin [at] postgresql.org<br>
<b>Subject:</b> Error when clustering a table<o:p></o:p></span></p>
</div>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I am trying to cluster a table for which vacuum =
full is not
reducing its size.<o:p></o:p></p>
<p class=3DMsoNormal>When I do so, I am getting the following =
error:<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>ERROR: missing chunk number 0 for toast value
207869115 in pg_toast_145099<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>********** Error **********<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>ERROR: missing chunk number 0 for toast value =
207869115 in
pg_toast_145099<o:p></o:p></p>
<p class=3DMsoNormal>SQL state: XX000<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Any idea how this can be remediated?<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>
------_=_NextPart_001_01CA7CF4.9CE1A6F2--
