Thread: Vacuum explained

Vacuum explained

From
"Gaetano Mendola"
Date:
Hi all,
again me on this argument.
Can some one explain the messages obtained during a vacuum?
For example this is a part ( in the attachment you'll find the entire log )
of what I obtain during the vacuum, now I do on my production DB a
vacuum each 60 minutes, before was twice in a Day.

NOTICE:  --Relation current_connection--
NOTICE:  Index current_connection_pkey: Pages 1442; Tuples 75489: Deleted
447.
        CPU 0.07s/0.07u sec elapsed 2.13 sec.
NOTICE:  Index idx_connected: Pages 9154; Tuples 75489: Deleted 447.
        CPU 1.13s/0.06u sec elapsed 45.85 sec.
NOTICE:  Index idx_ip_address: Pages 1216; Tuples 67385: Deleted 254.
        CPU 0.00s/0.05u sec elapsed 0.06 sec.
NOTICE:  Removed 447 tuples in 69 pages.
        CPU 0.00s/0.01u sec elapsed 0.01 sec.
NOTICE:  Pages 2518: Changed 38, Empty 0; Tup 75489: Vac 447, Keep 68661,
UnUsed 144574.
        Total CPU 1.31s/0.25u sec elapsed 48.23 sec.
NOTICE:  Analyzing current_connection



NOTICE:  --Relation ua_user_data_exp--
NOTICE:  Index ua_user_data_exp_id_user_key: Pages 657; Tuples 75600:
Deleted 3370.
        CPU 0.09s/0.07u sec elapsed 4.93 sec.
NOTICE:  Index ua_user_data_exp_login_key: Pages 1148; Tuples 75600: Deleted
3370.
        CPU 0.13s/0.04u sec elapsed 1.85 sec.
NOTICE:  Index exp_id_provider: Pages 1206; Tuples 75600: Deleted 3370.
        CPU 0.09s/0.08u sec elapsed 1.35 sec.
NOTICE:  Index exp_ci_login: Pages 1162; Tuples 75600: Deleted 3370.
        CPU 0.11s/0.09u sec elapsed 4.11 sec.
NOTICE:  Index exp_country: Pages 1393; Tuples 75600: Deleted 3370.
        CPU 0.16s/0.06u sec elapsed 5.73 sec.
NOTICE:  Index exp_os_type: Pages 1462; Tuples 75600: Deleted 3370.
        CPU 0.13s/0.09u sec elapsed 5.04 sec.
NOTICE:  Index exp_card: Pages 1551; Tuples 75600: Deleted 3370.
        CPU 0.21s/0.05u sec elapsed 5.71 sec.
NOTICE:  Index exp_status: Pages 1855; Tuples 75600: Deleted 3370.
        CPU 0.27s/0.12u sec elapsed 8.36 sec.
NOTICE:  Index exp_email: Pages 1949; Tuples 75609: Deleted 3370.
        CPU 0.21s/0.09u sec elapsed 6.48 sec.
NOTICE:  Index exp_ci_email: Pages 1977; Tuples 75609: Deleted 3370.
        CPU 0.39s/0.11u sec elapsed 6.64 sec.
NOTICE:  Index exp_lastname: Pages 1139; Tuples 75609: Deleted 3370.
        CPU 0.20s/0.07u sec elapsed 3.75 sec.
NOTICE:  Index exp_ci_lastname: Pages 1126; Tuples 75647: Deleted 3370.
        CPU 0.14s/0.08u sec elapsed 4.03 sec.
NOTICE:  Index exp_orbital_ptns: Pages 1571; Tuples 75693: Deleted 3370.
        CPU 0.16s/0.08u sec elapsed 8.16 sec.
NOTICE:  Index exp_stickers: Pages 1531; Tuples 75774: Deleted 3370.
        CPU 0.14s/0.04u sec elapsed 5.33 sec.
NOTICE:  Index exp_pid: Pages 1188; Tuples 75774: Deleted 3370.
        CPU 0.11s/0.07u sec elapsed 4.39 sec.
NOTICE:  Removed 3370 tuples in 469 pages.
        CPU 0.03s/0.08u sec elapsed 0.11 sec.
NOTICE:  Pages 33269: Changed 34, Empty 0; Tup 75600: Vac 3370, Keep 68772,
UnUsed 398696.
        Total CPU 4.70s/1.46u sec elapsed 78.43 sec.
NOTICE:  --Relation pg_toast_1062860--
NOTICE:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE:  Analyzing ua_user_data_exp


For example what is the meaning of UnUsed? Are pages not used until I'll do
a vacuum full ?

Should do I the vacuum more ofthen then 60 minutes ?





Ciao
Gaetano



begin 666 vacuum.empdb
M"DY/5$E#13H@("TM4F5L871I;VX@<&=?='EP92TM"DY/5$E#13H@(%!A9V5S
M(#4Z($-H86YG960@,"P@16UP='D@,#L@5'5P(#,Q,SH@5F%C(# L($ME97 @
M,"P@56Y5<V5D(#0W+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P
M<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=?='EP90I.3U1)
M0T4Z(" M+5)E;&%T:6]N('!G7V%T=')I8G5T92TM"DY/5$E#13H@(%!A9V5S
M(#,Y.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" R.3@P.B!686,@,"P@2V5E
M<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA
M<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G7V%T=')I8G5T
M90I.3U1)0T4Z(" M+5)E;&%T:6]N('!G7V-L87-S+2T*3D]424-%.B @4&%G
M97,@,3 Z($-H86YG960@,"P@16UP='D@,#L@5'5P(#,V,SH@5F%C(# L($ME
M97 @,"P@56Y5<V5D(#$X.2X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@
M96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G7V-L87-S
M"DY/5$E#13H@("TM4F5L871I;VX@<&=?9W)O=7 M+0I.3U1)0T4Z("!086=E
M<R Q.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" R.B!686,@,"P@2V5E<" P
M+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E
M9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G7V=R;W5P"DY/5$E#
M13H@("TM4F5L871I;VX@<&=?9&%T86)A<V4M+0I.3U1)0T4Z("!086=E<R Q
M.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" S.B!686,@,"P@2V5E<" P+"!5
M;E5S960@,BX*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P
M+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G7V1A=&%B87-E"DY/5$E#
M13H@("TM4F5L871I;VX@<&=?:6YH97)I=',M+0I.3U1)0T4Z("!086=E<R P
M.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5
M;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P
M+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G7VEN:&5R:71S"DY/5$E#
M13H@("TM4F5L871I;VX@<&=?:6YD97@M+0I.3U1)0T4Z("!086=E<R S.B!#
M:&%N9V5D(# L($5M<'1Y(# [(%1U<" Q,SDZ(%9A8R P+"!+965P(# L(%5N
M57-E9" X+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N
M,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=?:6YD97@*3D]424-%.B @
M+2U296QA=&EO;B!P9U]O<&5R871O<BTM"DY/5$E#13H@(%!A9V5S(#$P.B!#
M:&%N9V5D(# L($5M<'1Y(# [(%1U<" V,C,Z(%9A8R P+"!+965P(# L(%5N
M57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N
M,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=?;W!E<F%T;W(*3D]424-%
M.B @+2U296QA=&EO;B!P9U]O<&-L87-S+2T*3D]424-%.B @4&%G97,@,3H@
M0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @-3$Z(%9A8R P+"!+965P(# L(%5N
M57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N
M,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=?;W!C;&%S<PI.3U1)0T4Z
M(" M+5)E;&%T:6]N('!G7V%M+2T*3D]424-%.B @4&%G97,@,3H@0VAA;F=E
M9" P+"!%;7!T>2 P.R!4=7 @-#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N
M"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N
M"DY/5$E#13H@($%N86QY>FEN9R!P9U]A;0I.3U1)0T4Z(" M+5)E;&%T:6]N
M('!G7V%M;W M+0I.3U1)0T4Z("!086=E<R R.B!#:&%N9V5D(# L($5M<'1Y
M(# [(%1U<" Q.# Z(%9A8R P+"!+965P(# L(%5N57-E9" P+@H)5&]T86P@
M0U!5(# N,#%S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z
M("!!;F%L>7II;F<@<&=?86UO< I.3U1)0T4Z(" M+5)E;&%T:6]N('!G7V%M
M<')O8RTM"DY/5$E#13H@(%!A9V5S(#$Z($-H86YG960@,"P@16UP='D@,#L@
M5'5P(#4W.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P
M+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA
M;'EZ:6YG('!G7V%M<')O8PI.3U1)0T4Z(" M+5)E;&%T:6]N('!G7VQA;F=U
M86=E+2T*3D]424-%.B @4&%G97,@,3H@0VAA;F=E9" P+"!%;7!T>2 P.R!4
M=7 @-#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP
M,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@($%N86QY
M>FEN9R!P9U]L86YG=6%G90I.3U1)0T4Z(" M+5)E;&%T:6]N('!G7VQA<F=E
M;V)J96-T+2T*3D]424-%.B @4&%G97,@,#H@0VAA;F=E9" P+"!%;7!T>2 P
M.R!4=7 @,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@
M,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@($%N
M86QY>FEN9R!P9U]L87)G96]B:F5C= I.3U1)0T4Z(" M+5)E;&%T:6]N('!G
M7V%G9W)E9V%T92TM"DY/5$E#13H@(%!A9V5S(#$Z($-H86YG960@,"P@16UP
M='D@,#L@5'5P(#8P.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L
M($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%
M.B @06YA;'EZ:6YG('!G7V%G9W)E9V%T90I.3U1)0T4Z(" M+5)E;&%T:6]N
M('!G7W1R:6=G97(M+0I.3U1)0T4Z("!086=E<R T.B!#:&%N9V5D(# L($5M
M<'1Y(# [(%1U<" Q-#0Z(%9A8R P+"!+965P(# L(%5N57-E9" Q,"X*"51O
M=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]4
M24-%.B @06YA;'EZ:6YG('!G7W1R:6=G97(*3D]424-%.B @+2U296QA=&EO
M;B!P9U]L:7-T96YE<BTM"DY/5$E#13H@(%!A9V5S(# Z($-H86YG960@,"P@
M16UP='D@,#L@5'5P(# Z(%9A8R P+"!+965P(# L(%5N57-E9" P+@H)5&]T
M86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)
M0T4Z("!!;F%L>7II;F<@<&=?;&ES=&5N97(*3D]424-%.B @+2U296QA=&EO
M;B!P9U]S:&%D;W<M+0I.3U1)0T4Z("!086=E<R Q.B!#:&%N9V5D(# L($5M
M<'1Y(# [(%1U<" V.3H@5F%C(# L($ME97 @,"P@56Y5<V5D(#$X+@H)5&]T
M86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)
M0T4Z("!!;F%L>7II;F<@<&=?<VAA9&]W"DY/5$E#13H@("TM4F5L871I;VX@
M<&=?871T<F1E9BTM"DY/5$E#13H@(%!A9V5S(#(Z($-H86YG960@,"P@16UP
M='D@,#L@5'5P(#<V.B!686,@,"P@2V5E<" P+"!5;E5S960@,2X*"51O=&%L
M($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%
M.B @+2U296QA=&EO;B!P9U]T;V%S=%\Q-C,X-"TM"DY/5$E#13H@(%!A9V5S
M(# Z($-H86YG960@,"P@16UP='D@,#L@5'5P(# Z(%9A8R P+"!+965P(# L
M(%5N57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D
M(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=?871T<F1E9@I.3U1)
M0T4Z(" M+5)E;&%T:6]N('!G7V1E<V-R:7!T:6]N+2T*3D]424-%.B @4&%G
M97,@,3(Z($-H86YG960@,"P@16UP='D@,#L@5'5P(#$S,#,Z(%9A8R P+"!+
M965P(# L(%5N57-E9" P+@H)5&]T86P@0U!5(# N,#%S+S N,#!U('-E8R!E
M;&%P<V5D(# N,#(@<V5C+@I.3U1)0T4Z(" M+5)E;&%T:6]N('!G7W1O87-T
M7S$V-#$V+2T*3D]424-%.B @4&%G97,@,#H@0VAA;F=E9" P+"!%;7!T>2 P
M.R!4=7 @,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@
M,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@($%N
M86QY>FEN9R!P9U]D97-C<FEP=&EO;@I.3U1)0T4Z(" M+5)E;&%T:6]N('!G
M7W!R;V,M+0I.3U1)0T4Z("!086=E<R T.3H@0VAA;F=E9" P+"!%;7!T>2 P
M.R!4=7 @,30R.#H@5F%C(# L($ME97 @,"P@56Y5<V5D(#(X+@H)5&]T86P@
M0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z
M(" M+5)E;&%T:6]N('!G7W1O87-T7S$R-34M+0I.3U1)0T4Z("!086=E<R P
M.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5
M;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P
M+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G7W!R;V,*3D]424-%.B @
M+2U296QA=&EO;B!P9U]R96QC:&5C:RTM"DY/5$E#13H@(%!A9V5S(#(Z($-H
M86YG960@,"P@16UP='D@,#L@5'5P(#,W.B!686,@,"P@2V5E<" P+"!5;E5S
M960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P
M('-E8RX*3D]424-%.B @+2U296QA=&EO;B!P9U]T;V%S=%\Q-C,X-BTM"DY/
M5$E#13H@(%!A9V5S(# Z($-H86YG960@,"P@16UP='D@,#L@5'5P(# Z(%9A
M8R P+"!+965P(# L(%5N57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U
M('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=?
M<F5L8VAE8VL*3D]424-%.B @+2U296QA=&EO;B!P9U]R97=R:71E+2T*3D]4
M24-%.B @4&%G97,@,3DZ($-H86YG960@,"P@16UP='D@,#L@5'5P(#$R,#H@
M5F%C(# L($ME97 @,"P@56Y5<V5D(#8N"@E4;W1A;"!#4%4@,"XP,',O,"XP
M,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@("TM4F5L871I;VX@
M<&=?=&]A<W1?,38T,3 M+0I.3U1)0T4Z("!086=E<R W.B!#:&%N9V5D(# L
M($5M<'1Y(# [(%1U<" S,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(#4N"@E4
M;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/
M5$E#13H@($%N86QY>FEN9R!P9U]R97=R:71E"DY/5$E#13H@("TM4F5L871I
M;VX@<&=?<W1A=&ES=&EC+2T*3D]424-%.B @4&%G97,@-3 S.B!#:&%N9V5D
M(#0S+"!%;7!T>2 P.R!4=7 @.38P.#H@5F%C(# L($ME97 @.3(R."P@56Y5
M<V5D(#(R-C@N"@E4;W1A;"!#4%4@,"XP,G,O,"XP,'4@<V5C(&5L87!S960@
M,"XR-B!S96,N"DY/5$E#13H@("TM4F5L871I;VX@<&=?=&]A<W1?,38T,#@M
M+0I.3U1)0T4Z("!086=E<R P.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P
M.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P
M+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @+2U296QA=&EO
M;B!A9&UI;FES=')A=&]R<RTM"DY/5$E#13H@(%!A9V5S(#(Z($-H86YG960@
M,"P@16UP='D@,#L@5'5P(#8Q.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*
M"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*
M3D]424-%.B @+2U296QA=&EO;B!P9U]T;V%S=%\W-# X.3(M+0I.3U1)0T4Z
M("!086=E<R P.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@
M2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@
M96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG(&%D;6EN:7-T
M<F%T;W)S"DY/5$E#13H@("TM4F5L871I;VX@8V%S7W-E<G9I8V4M+0I.3U1)
M0T4Z("!086=E<R Q.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" Q.B!686,@
M,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S
M96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG(&-A<U]S
M97)V:6-E"DY/5$E#13H@("TM4F5L871I;VX@8V%S7W-E<G9I8V5?:V5Y+2T*
M3D]424-%.B @4&%G97,@,CH@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @,3 W
M.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P
M+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG
M(&-A<U]S97)V:6-E7VME>0I.3U1)0T4Z(" M+5)E;&%T:6]N(&-A<U]S=6)S
M8W)I<'1I;VXM+0I.3U1)0T4Z("!086=E<R Q.B!#:&%N9V5D(# L($5M<'1Y
M(# [(%1U<" V-3H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#
M4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@
M($%N86QY>FEN9R!C87-?<W5B<V-R:7!T:6]N"DY/5$E#13H@("TM4F5L871I
M;VX@8V%S7W5S97)?:V5Y<RTM"DY/5$E#13H@(%!A9V5S(#<Z($-H86YG960@
M,2P@16UP='D@,#L@5'5P(#0V,SH@5F%C(# L($ME97 @-2P@56Y5<V5D(#<N
M"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N
M"DY/5$E#13H@($%N86QY>FEN9R!C87-?=7-E<E]K97ES"DY/5$E#13H@("TM
M4F5L871I;VX@8VQA<W-?9&5F875L="TM"DY/5$E#13H@(%!A9V5S(#$Z($-H
M86YG960@,"P@16UP='D@,#L@5'5P(#$X.B!686,@,"P@2V5E<" P+"!5;E5S
M960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P
M('-E8RX*3D]424-%.B @06YA;'EZ:6YG(&-L87-S7V1E9F%U;'0*3D]424-%
M.B @+2U296QA=&EO;B!C;VYN96-T:6]N7V1A=&$M+0I.3U1)0T4Z("!086=E
M<R V-3H@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @-C@S,3H@5F%C(# L($ME
M97 @,RP@56Y5<V5D(#(W+@H)5&]T86P@0U!5(# N,#!S+S N,#%U('-E8R!E
M;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@8V]N;F5C=&EO
M;E]D871A"DY/5$E#13H@("TM4F5L871I;VX@8V]N=')A8W1S+2T*3D]424-%
M.B @4&%G97,@-#H@0VAA;F=E9" Q+"!%;7!T>2 P.R!4=7 @,C(S.B!686,@
M,"P@2V5E<" T-"P@56Y5<V5D(#(S+@H)5&]T86P@0U!5(# N,#!S+S N,#!U
M('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@8V]N
M=')A8W1S"DY/5$E#13H@("TM4F5L871I;VX@8V]N=')A8W1S7V-A<U]S97)V
M:6-E+2T*3D]424-%.B @4&%G97,@,3H@0VAA;F=E9" P+"!%;7!T>2 P.R!4
M=7 @,C Z(%9A8R P+"!+965P(# L(%5N57-E9" P+@H)5&]T86P@0U!5(# N
M,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L
M>7II;F<@8V]N=')A8W1S7V-A<U]S97)V:6-E"DY/5$E#13H@("TM4F5L871I
M;VX@8V]N=')A8W1S7W!I9',M+0I.3U1)0T4Z("!086=E<R S.B!#:&%N9V5D
M(# L($5M<'1Y(# [(%1U<" T,C Z(%9A8R P+"!+965P(# L(%5N57-E9" P
M+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C
M+@I.3U1)0T4Z("!!;F%L>7II;F<@8V]N=')A8W1S7W!I9',*3D]424-%.B @
M+2U296QA=&EO;B!C;VYT<F%C='-?<&QA=&9O<FUS+2T*3D]424-%.B @4&%G
M97,@,CH@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @,C$Y.B!686,@,"P@2V5E
M<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA
M<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG(&-O;G1R86-T<U]P
M;&%T9F]R;7,*3D]424-%.B @+2U296QA=&EO;B!C=7)R96YT7V-O;FYE8W1I
M;VXM+0I.3U1)0T4Z("!);F1E>"!C=7)R96YT7V-O;FYE8W1I;VY?<&ME>3H@
M4&%G97,@,30T,CL@5'5P;&5S(#<U-#@Y.B!$96QE=&5D(#0T-RX*"4-052 P
M+C W<R\P+C W=2!S96,@96QA<'-E9" R+C$S('-E8RX*3D]424-%.B @26YD
M97@@:61X7V-O;FYE8W1E9#H@4&%G97,@.3$U-#L@5'5P;&5S(#<U-#@Y.B!$
M96QE=&5D(#0T-RX*"4-052 Q+C$S<R\P+C V=2!S96,@96QA<'-E9" T-2XX
M-2!S96,N"DY/5$E#13H@($EN9&5X(&ED>%]I<%]A9&1R97-S.B!086=E<R Q
M,C$V.R!4=7!L97,@-C<S.#4Z($1E;&5T960@,C4T+@H)0U!5(# N,#!S+S N
M,#5U('-E8R!E;&%P<V5D(# N,#8@<V5C+@I.3U1)0T4Z("!296UO=F5D(#0T
M-R!T=7!L97,@:6X@-CD@<&%G97,N"@E#4%4@,"XP,',O,"XP,74@<V5C(&5L
M87!S960@,"XP,2!S96,N"DY/5$E#13H@(%!A9V5S(#(U,3@Z($-H86YG960@
M,S@L($5M<'1Y(# [(%1U<" W-30X.3H@5F%C(#0T-RP@2V5E<" V.#8V,2P@
M56Y5<V5D(#$T-#4W-"X*"51O=&%L($-052 Q+C,Q<R\P+C(U=2!S96,@96QA
M<'-E9" T."XR,R!S96,N"DY/5$E#13H@($%N86QY>FEN9R!C=7)R96YT7V-O
M;FYE8W1I;VX*3D]424-%.B @+2U296QA=&EO;B!E;6TM+0I.3U1)0T4Z("!0
M86=E<R Q.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" Q,#<Z(%9A8R P+"!+
M965P(# L(%5N57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E
M;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@96UM"DY/5$E#
M13H@("TM4F5L871I;VX@9G5N8W1I;VY?;F%M92TM"DY/5$E#13H@(%!A9V5S
M(#(Z($-H86YG960@,"P@16UP='D@,#L@5'5P(#$Q,3H@5F%C(# L($ME97 @
M,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S
M960@,"XP,"!S96,N"DY/5$E#13H@("TM4F5L871I;VX@<&=?=&]A<W1?-S0P
M-S@V+2T*3D]424-%.B @4&%G97,@,#H@0VAA;F=E9" P+"!%;7!T>2 P.R!4
M=7 @,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP
M,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@($%N86QY
M>FEN9R!F=6YC=&EO;E]N86UE"DY/5$E#13H@("TM4F5L871I;VX@9V%T97=A
M>7,M+0I.3U1)0T4Z("!086=E<R Q.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U
M<" Q,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(#(N"@E4;W1A;"!#4%4@,"XP
M,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@("TM4F5L
M871I;VX@<&=?=&]A<W1?-S0P-CDS+2T*3D]424-%.B @4&%G97,@,#H@0VAA
M;F=E9" P+"!%;7!T>2 P.R!4=7 @,#H@5F%C(# L($ME97 @,"P@56Y5<V5D
M(# N"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S
M96,N"DY/5$E#13H@($%N86QY>FEN9R!G871E=V%Y<PI.3U1)0T4Z(" M+5)E
M;&%T:6]N(&QA<W1?8V]N;F5C=&EO;BTM"DY/5$E#13H@($EN9&5X(&QA<W1?
M8V]N;F5C=&EO;E]P:V5Y.B!086=E<R Q,SD[(%1U<&QE<R Q,C T-SH@1&5L
M971E9" U+@H)0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,#4@<V5C
M+@I.3U1)0T4Z("!296UO=F5D(#4@='5P;&5S(&EN(#$@<&%G97,N"@E#4%4@
M,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@(%!A
M9V5S(#(Y,3H@0VAA;F=E9" S,RP@16UP='D@,#L@5'5P(#$R,#0W.B!686,@
M-2P@2V5E<" V,S4R+"!5;E5S960@,38R-3(N"@E4;W1A;"!#4%4@,"XP,W,O
M,"XP,'4@<V5C(&5L87!S960@,"XP."!S96,N"DY/5$E#13H@($%N86QY>FEN
M9R!L87-T7V-O;FYE8W1I;VX*3D]424-%.B @+2U296QA=&EO;B!L;V=I;BTM
M"DY/5$E#13H@(%!A9V5S(#,X-#H@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @
M-#DX.#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP
M-',O,"XP,'4@<V5C(&5L87!S960@,"XP-"!S96,N"DY/5$E#13H@($%N86QY
M>FEN9R!L;V=I;@I.3U1)0T4Z(" M+5)E;&%T:6]N(&QO;VMU<%]T86)L97,M
M+0I.3U1)0T4Z("!086=E<R Q,SH@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @
M,3,V,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(#DV+@H)5&]T86P@0U!5(# N
M,#%S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L
M>7II;F<@;&]O:W5P7W1A8FQE<PI.3U1)0T4Z(" M+5)E;&%T:6]N('!G85]F
M;W)M<RTM"DY/5$E#13H@(%!A9V5S(# Z($-H86YG960@,"P@16UP='D@,#L@
M5'5P(# Z(%9A8R P+"!+965P(# L(%5N57-E9" P+@H)5&]T86P@0U!5(# N
M,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z(" M+5)E
M;&%T:6]N('!G7W1O87-T7S<T,#DW-2TM"DY/5$E#13H@(%!A9V5S(# Z($-H
M86YG960@,"P@16UP='D@,#L@5'5P(# Z(%9A8R P+"!+965P(# L(%5N57-E
M9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @
M<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=A7V9O<FUS"DY/5$E#13H@("TM
M4F5L871I;VX@<&=A7W%U97)I97,M+0I.3U1)0T4Z("!086=E<R P.B!#:&%N
M9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5;E5S960@
M,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E
M8RX*3D]424-%.B @+2U296QA=&EO;B!P9U]T;V%S=%\W-# Y-S M+0I.3U1)
M0T4Z("!086=E<R P.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@
M,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S
M96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('!G85]Q
M=65R:65S"DY/5$E#13H@("TM4F5L871I;VX@<&=A7W)E<&]R=',M+0I.3U1)
M0T4Z("!086=E<R P.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@
M,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S
M96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @+2U296QA=&EO;B!P9U]T
M;V%S=%\W-# Y.#4M+0I.3U1)0T4Z("!086=E<R P.B!#:&%N9V5D(# L($5M
M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L
M($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%
M.B @06YA;'EZ:6YG('!G85]R97!O<G1S"DY/5$E#13H@("TM4F5L871I;VX@
M<&=A7W-C:&5M82TM"DY/5$E#13H@(%!A9V5S(# Z($-H86YG960@,"P@16UP
M='D@,#L@5'5P(# Z(%9A8R P+"!+965P(# L(%5N57-E9" P+@H)5&]T86P@
M0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z
M(" M+5)E;&%T:6]N('!G7W1O87-T7S<T,#DY,"TM"DY/5$E#13H@(%!A9V5S
M(# Z($-H86YG960@,"P@16UP='D@,#L@5'5P(# Z(%9A8R P+"!+965P(# L
M(%5N57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D
M(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<&=A7W-C:&5M80I.3U1)
M0T4Z(" M+5)E;&%T:6]N('!G85]S8W)I<'1S+2T*3D]424-%.B @4&%G97,@
M,#H@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @,#H@5F%C(# L($ME97 @,"P@
M56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@
M,"XP,"!S96,N"DY/5$E#13H@("TM4F5L871I;VX@<&=?=&]A<W1?-S0P.3@P
M+2T*3D]424-%.B @4&%G97,@,#H@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @
M,#H@5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP,',O
M,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@($%N86QY>FEN
M9R!P9V%?<V-R:7!T<PI.3U1)0T4Z(" M+5)E;&%T:6]N('!L871F;W)M<RTM
M"DY/5$E#13H@(%!A9V5S(#$Z($-H86YG960@,"P@16UP='D@,#L@5'5P(#@Z
M(%9A8R P+"!+965P(# L(%5N57-E9" Q+@H)5&]T86P@0U!5(# N,#!S+S N
M,#!U('-E8R!E;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z(" M+5)E;&%T:6]N
M('!G7W1O87-T7S$P-38R-3DM+0I.3U1)0T4Z("!086=E<R P.B!#:&%N9V5D
M(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*
M"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*
M3D]424-%.B @06YA;'EZ:6YG('!L871F;W)M<PI.3U1)0T4Z(" M+5)E;&%T
M:6]N('!R;W9I9&5R7V9U;F-T:6]N+2T*3D]424-%.B @4&%G97,@,3H@0VAA
M;F=E9" P+"!%;7!T>2 P.R!4=7 @,3H@5F%C(# L($ME97 @,"P@56Y5<V5D
M(# N"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S
M96,N"DY/5$E#13H@($%N86QY>FEN9R!P<F]V:61E<E]F=6YC=&EO;@I.3U1)
M0T4Z(" M+5)E;&%T:6]N('!R;W9I9&5R<RTM"DY/5$E#13H@(%!A9V5S(#(Z
M($-H86YG960@,"P@16UP='D@,#L@5'5P(#4S.B!686,@,"P@2V5E<" T,BP@
M56Y5<V5D(#$V+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E;&%P<V5D
M(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<')O=FED97)S"DY/5$E#
M13H@("TM4F5L871I;VX@<W1A='5S7W1R86YS:6-T:6]N<RTM"DY/5$E#13H@
M(%!A9V5S(#$Z($-H86YG960@,"P@16UP='D@,#L@5'5P(#$P.B!686,@,"P@
M2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@
M96QA<'-E9" P+C P('-E8RX*3D]424-%.B @+2U296QA=&EO;B!P9U]T;V%S
M=%\W-# W.34M+0I.3U1)0T4Z("!086=E<R P.B!#:&%N9V5D(# L($5M<'1Y
M(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-0
M52 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @
M06YA;'EZ:6YG('-T871U<U]T<F%N<VEC=&EO;G,*3D]424-%.B @+2U296QA
M=&EO;B!S=&EC:V5R<RTM"DY/5$E#13H@(%!A9V5S(#$Z($-H86YG960@,"P@
M16UP='D@,#L@5'5P(#0Q.B!686,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O
M=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]4
M24-%.B @+2U296QA=&EO;B!P9U]T;V%S=%\W-# W,3@M+0I.3U1)0T4Z("!0
M86=E<R P.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E
M<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA
M<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('-T:6-K97)S"DY/
M5$E#13H@("TM4F5L871I;VX@<W5P<&]R=&5D7V-A<F1S+2T*3D]424-%.B @
M4&%G97,@,3H@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @,S$Z(%9A8R P+"!+
M965P(# L(%5N57-E9" P+@H)5&]T86P@0U!5(# N,#!S+S N,#!U('-E8R!E
M;&%P<V5D(# N,# @<V5C+@I.3U1)0T4Z("!!;F%L>7II;F<@<W5P<&]R=&5D
M7V-A<F1S"DY/5$E#13H@("TM4F5L871I;VX@=')A;G-A8W1I;VY?:&ES=&]R
M>2TM"DY/5$E#13H@(%!A9V5S(#,T.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U
M<" T-C T.B!686,@,"P@2V5E<" P+"!5;E5S960@-"X*"51O=&%L($-052 P
M+C Q<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA
M;'EZ:6YG('1R86YS86-T:6]N7VAI<W1O<GD*3D]424-%.B @+2U296QA=&EO
M;B!T<F%N<V%C=&EO;G,M+0I.3U1)0T4Z("!086=E<R S,SH@0VAA;F=E9" Q
M-BP@16UP='D@,#L@5'5P(#,X,#DZ(%9A8R P+"!+965P(#,W+"!5;E5S960@
M.#,N"@E4;W1A;"!#4%4@,"XP,7,O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S
M96,N"DY/5$E#13H@($%N86QY>FEN9R!T<F%N<V%C=&EO;G,*3D]424-%.B @
M+2U296QA=&EO;B!T<F%N<W!O;F1E<G,M+0I.3U1)0T4Z("!086=E<R Q.B!#
M:&%N9V5D(# L($5M<'1Y(# [(%1U<" Q,#H@5F%C(# L($ME97 @,"P@56Y5
M<V5D(# N"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP
M,"!S96,N"DY/5$E#13H@($%N86QY>FEN9R!T<F%N<W!O;F1E<G,*3D]424-%
M.B @+2U296QA=&EO;B!U85]U<V5R7V1A=&%?97AP+2T*3D]424-%.B @26YD
M97@@=6%?=7-E<E]D871A7V5X<%]I9%]U<V5R7VME>3H@4&%G97,@-C4W.R!4
M=7!L97,@-S4V,# Z($1E;&5T960@,S,W,"X*"4-052 P+C Y<R\P+C W=2!S
M96,@96QA<'-E9" T+CDS('-E8RX*3D]424-%.B @26YD97@@=6%?=7-E<E]D
M871A7V5X<%]L;V=I;E]K97DZ(%!A9V5S(#$Q-#@[(%1U<&QE<R W-38P,#H@
M1&5L971E9" S,S<P+@H)0U!5(# N,3-S+S N,#1U('-E8R!E;&%P<V5D(#$N
M.#4@<V5C+@I.3U1)0T4Z("!);F1E>"!E>'!?:61?<')O=FED97(Z(%!A9V5S
M(#$R,#8[(%1U<&QE<R W-38P,#H@1&5L971E9" S,S<P+@H)0U!5(# N,#ES
M+S N,#AU('-E8R!E;&%P<V5D(#$N,S4@<V5C+@I.3U1)0T4Z("!);F1E>"!E
M>'!?8VE?;&]G:6XZ(%!A9V5S(#$Q-C([(%1U<&QE<R W-38P,#H@1&5L971E
M9" S,S<P+@H)0U!5(# N,3%S+S N,#EU('-E8R!E;&%P<V5D(#0N,3$@<V5C
M+@I.3U1)0T4Z("!);F1E>"!E>'!?8V]U;G1R>3H@4&%G97,@,3,Y,SL@5'5P
M;&5S(#<U-C P.B!$96QE=&5D(#,S-S N"@E#4%4@,"XQ-G,O,"XP-G4@<V5C
M(&5L87!S960@-2XW,R!S96,N"DY/5$E#13H@($EN9&5X(&5X<%]O<U]T>7!E
M.B!086=E<R Q-#8R.R!4=7!L97,@-S4V,# Z($1E;&5T960@,S,W,"X*"4-0
M52 P+C$S<R\P+C Y=2!S96,@96QA<'-E9" U+C T('-E8RX*3D]424-%.B @
M26YD97@@97AP7V-A<F0Z(%!A9V5S(#$U-3$[(%1U<&QE<R W-38P,#H@1&5L
M971E9" S,S<P+@H)0U!5(# N,C%S+S N,#5U('-E8R!E;&%P<V5D(#4N-S$@
M<V5C+@I.3U1)0T4Z("!);F1E>"!E>'!?<W1A='5S.B!086=E<R Q.#4U.R!4
M=7!L97,@-S4V,# Z($1E;&5T960@,S,W,"X*"4-052 P+C(W<R\P+C$R=2!S
M96,@96QA<'-E9" X+C,V('-E8RX*3D]424-%.B @26YD97@@97AP7V5M86EL
M.B!086=E<R Q.30Y.R!4=7!L97,@-S4V,#DZ($1E;&5T960@,S,W,"X*"4-0
M52 P+C(Q<R\P+C Y=2!S96,@96QA<'-E9" V+C0X('-E8RX*3D]424-%.B @
M26YD97@@97AP7V-I7V5M86EL.B!086=E<R Q.3<W.R!4=7!L97,@-S4V,#DZ
M($1E;&5T960@,S,W,"X*"4-052 P+C,Y<R\P+C$Q=2!S96,@96QA<'-E9" V
M+C8T('-E8RX*3D]424-%.B @26YD97@@97AP7VQA<W1N86UE.B!086=E<R Q
M,3,Y.R!4=7!L97,@-S4V,#DZ($1E;&5T960@,S,W,"X*"4-052 P+C(P<R\P
M+C W=2!S96,@96QA<'-E9" S+C<U('-E8RX*3D]424-%.B @26YD97@@97AP
M7V-I7VQA<W1N86UE.B!086=E<R Q,3(V.R!4=7!L97,@-S4V-#<Z($1E;&5T
M960@,S,W,"X*"4-052 P+C$T<R\P+C X=2!S96,@96QA<'-E9" T+C S('-E
M8RX*3D]424-%.B @26YD97@@97AP7V]R8FET86Q?<'1N<SH@4&%G97,@,34W
M,3L@5'5P;&5S(#<U-CDS.B!$96QE=&5D(#,S-S N"@E#4%4@,"XQ-G,O,"XP
M.'4@<V5C(&5L87!S960@."XQ-B!S96,N"DY/5$E#13H@($EN9&5X(&5X<%]S
M=&EC:V5R<SH@4&%G97,@,34S,3L@5'5P;&5S(#<U-S<T.B!$96QE=&5D(#,S
M-S N"@E#4%4@,"XQ-',O,"XP-'4@<V5C(&5L87!S960@-2XS,R!S96,N"DY/
M5$E#13H@($EN9&5X(&5X<%]P:60Z(%!A9V5S(#$Q.#@[(%1U<&QE<R W-3<W
M-#H@1&5L971E9" S,S<P+@H)0U!5(# N,3%S+S N,#=U('-E8R!E;&%P<V5D
M(#0N,SD@<V5C+@I.3U1)0T4Z("!296UO=F5D(#,S-S @='5P;&5S(&EN(#0V
M.2!P86=E<RX*"4-052 P+C S<R\P+C X=2!S96,@96QA<'-E9" P+C$Q('-E
M8RX*3D]424-%.B @4&%G97,@,S,R-CDZ($-H86YG960@,S0L($5M<'1Y(# [
M(%1U<" W-38P,#H@5F%C(#,S-S L($ME97 @-C@W-S(L(%5N57-E9" S.3@V
M.38N"@E4;W1A;"!#4%4@-"XW,',O,2XT-G4@<V5C(&5L87!S960@-S@N-#,@
M<V5C+@I.3U1)0T4Z(" M+5)E;&%T:6]N('!G7W1O87-T7S$P-C(X-C M+0I.
M3U1)0T4Z("!086=E<R P.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!6
M86,@,"P@2V5E<" P+"!5;E5S960@,"X*"51O=&%L($-052 P+C P<R\P+C P
M=2!S96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @06YA;'EZ:6YG('5A
M7W5S97)?9&%T85]E>' *3D]424-%.B @+2U296QA=&EO;B!U<V5R7V1A=&$M
M+0I.3U1)0T4Z("!086=E<R Q.#8Z($-H86YG960@,"P@16UP='D@,#L@5'5P
M(#8X,S(Z(%9A8R P+"!+965P(#,L(%5N57-E9" V-RX*"51O=&%L($-052 P
M+C R<R\P+C P=2!S96,@96QA<'-E9" P+C Q('-E8RX*3D]424-%.B @+2U2
M96QA=&EO;B!P9U]T;V%S=%\W-# X-S,M+0I.3U1)0T4Z("!086=E<R P.B!#
M:&%N9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5;E5S
M960@,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P
M('-E8RX*3D]424-%.B @06YA;'EZ:6YG('5S97)?9&%T80I.3U1)0T4Z(" M
M+5)E;&%T:6]N('5S97)?9W)O=7 M+0I.3U1)0T4Z("!086=E<R P.B!#:&%N
M9V5D(# L($5M<'1Y(# [(%1U<" P.B!686,@,"P@2V5E<" P+"!5;E5S960@
M,"X*"51O=&%L($-052 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C P('-E
M8RX*3D]424-%.B @06YA;'EZ:6YG('5S97)?9W)O=7 *3D]424-%.B @+2U2
M96QA=&EO;B!U<V5R7VQO9VEN+2T*3D]424-%.B @4&%G97,@-#4Z($-H86YG
M960@,C8L($5M<'1Y(# [(%1U<" V.#,R.B!686,@,"P@2V5E<" S+"!5;E5S
M960@,C8N"@E4;W1A;"!#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP
M,"!S96,N"DY/5$E#13H@("TM4F5L871I;VX@<&=?=&]A<W1?-S0P-S,R+2T*
M3D]424-%.B @4&%G97,@,#H@0VAA;F=E9" P+"!%;7!T>2 P.R!4=7 @,#H@
M5F%C(# L($ME97 @,"P@56Y5<V5D(# N"@E4;W1A;"!#4%4@,"XP,',O,"XP
M,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/5$E#13H@($%N86QY>FEN9R!U
M<V5R7VQO9VEN"DY/5$E#13H@("TM4F5L871I;VX@=7-E<E]L;V=I;E]S=&EC
M:V5R+2T*3D]424-%.B @4&%G97,@,3@Z($-H86YG960@,"P@16UP='D@,#L@
M5'5P(#,R,S<Z(%9A8R P+"!+965P(#$L(%5N57-E9" Q-BX*"51O=&%L($-0
M52 P+C P<R\P+C P=2!S96,@96QA<'-E9" P+C S('-E8RX*3D]424-%.B @
M06YA;'EZ:6YG('5S97)?;&]G:6Y?<W1I8VME<@I.3U1)0T4Z(" M+5)E;&%T
M:6]N('5S97)?;&]G<RTM"DY/5$E#13H@($EN9&5X('5S97)?;&]G<U]P:V5Y
M.B!086=E<R Q,S(V.R!4=7!L97,@-3(P-C(Y.B!$96QE=&5D(#4N"@E#4%4@
M,"XR,',O,"XQ,'4@<V5C(&5L87!S960@,2XR-"!S96,N"DY/5$E#13H@($EN
M9&5X(&ED>%]U<V5R7W5S97)?;&]G<SH@4&%G97,@,3,Y,SL@5'5P;&5S(#4R
M,#8R.3H@1&5L971E9" U+@H)0U!5(# N,3=S+S N,#EU('-E8R!E;&%P<V5D
M(#,N,C<@<V5C+@I.3U1)0T4Z("!296UO=F5D(#4@='5P;&5S(&EN(#(@<&%G
M97,N"@E#4%4@,"XP,',O,"XP,'4@<V5C(&5L87!S960@,"XP,"!S96,N"DY/
M5$E#13H@(%!A9V5S(#4U-#$Z($-H86YG960@-BP@16UP='D@,#L@5'5P(#4R
M,#8R.3H@5F%C(#4L($ME97 @,"P@56Y5<V5D(#(T-2X*"51O=&%L($-052 P
M+CDV<R\P+C(W=2!S96,@96QA<'-E9" W+C$P('-E8RX*3D]424-%.B @06YA
M;'EZ:6YG('5S97)?;&]G<PI.3U1)0T4Z(" M+5)E;&%T:6]N('5S97)?;&]G
M<U]D:6=E<W0M+0I.3U1)0T4Z("!);F1E>"!U<V5R7VQO9W-?9&EG97-T7W!K
M97DZ(%!A9V5S(#$S-#L@5'5P;&5S(#$S,3@S.B!$96QE=&5D(#4N"@E#4%4@
M,"XP,G,O,"XP,'4@<V5C(&5L87!S960@,"XR,2!S96,N"DY/5$E#13H@(%)E
M;6]V960@-2!T=7!L97,@:6X@,R!P86=E<RX*"4-052 P+C P<R\P+C P=2!S
M96,@96QA<'-E9" P+C P('-E8RX*3D]424-%.B @4&%G97,@,C$Y.B!#:&%N
M9V5D(#,V+"!%;7!T>2 P.R!4=7 @,3,Q.#,Z(%9A8R U+"!+965P(#8S-34L
M(%5N57-E9" Q-38V,RX*"51O=&%L($-052 P+C T<R\P+C P=2!S96,@96QA
M<'-E9" P+C0X('-E8RX*3D]424-%.B @06YA;'EZ:6YG('5S97)?;&]G<U]D
M:6=E<W0*3D]424-%.B @+2U296QA=&EO;B!U<V5R7VYO=&5S+2T*3D]424-%
M.B @4&%G97,@,C0X.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" R,C8T-CH@
M5F%C(# L($ME97 @,"P@56Y5<V5D(#$N"@E4;W1A;"!#4%4@,"XP-',O,"XP
M,74@<V5C(&5L87!S960@,"XR,"!S96,N"DY/5$E#13H@($%N86QY>FEN9R!U
M<V5R7VYO=&5S"DY/5$E#13H@("TM4F5L871I;VX@=7-E<E]T<F%F9FEC+2T*
M3D]424-%.B @26YD97@@=7-E<E]T<F%F9FEC7W!K97DZ(%!A9V5S(#$W-3([
M(%1U<&QE<R V.30U,3H@1&5L971E9" S+@H)0U!5(# N,C5S+S N,#)U('-E
M8R!E;&%P<V5D(#0N.3(@<V5C+@I.3U1)0T4Z("!);F1E>"!I9'A?=7-E<E]U
M<V5R7W1R869F:6,Z(%!A9V5S(#$T,C,[(%1U<&QE<R V.30U,3H@1&5L971E
M9" S+@H)0U!5(# N,3)S+S N,#9U('-E8R!E;&%P<V5D(#,N-#@@<V5C+@I.
M3U1)0T4Z("!);F1E>"!I9'A?8V]N=')A8W1?=7-E<E]T<F%F9FEC.B!086=E
M<R X-C,W.R!4=7!L97,@-CDT-3,Z($1E;&5T960@,RX*"4-052 P+CDV<R\P
M+C X=2!S96,@96QA<'-E9" S,BXU-R!S96,N"DY/5$E#13H@(%)E;6]V960@
M,R!T=7!L97,@:6X@,R!P86=E<RX*"4-052 P+C P<R\P+C P=2!S96,@96QA
M<'-E9" P+C P('-E8RX*3D]424-%.B @4&%G97,@,3DX,CH@0VAA;F=E9" P
M+"!%;7!T>2 P.R!4=7 @-CDT-3$Z(%9A8R S+"!+965P(#8R,34P+"!5;E5S
M960@,38V-38Q+@H)5&]T86P@0U!5(#$N,S-S+S N,C!U('-E8R!E;&%P<V5D
M(#0Q+C X('-E8RX*3D]424-%.B @06YA;'EZ:6YG('5S97)?=')A9F9I8PI.
M3U1)0T4Z(" M+5)E;&%T:6]N('5S97)S+2T*3D]424-%.B @4&%G97,@,S4W
M.B!#:&%N9V5D(# L($5M<'1Y(# [(%1U<" T.3DP.B!686,@,"P@2V5E<" P
M+"!5;E5S960@,"X*"51O=&%L($-052 P+C U<R\P+C P=2!S96,@96QA<'-E
M9" P+C$S('-E8RX*3D]424-%.B @06YA;'EZ:6YG('5S97)S"E9!0U5530H*
`
end


Re: Vacuum explained

From
Robert Treat
Date:
This is a rough description, should anyone see a need to correct it
please do so.

On Sat, 2003-01-04 at 09:42, Gaetano Mendola wrote:
> NOTICE:  Pages 2518: Changed 38, Empty 0; Tup 75489: Vac 447, Keep 68661,
> UnUsed 144574.
>         Total CPU 1.31s/0.25u sec elapsed 48.23 sec.

Pages = the # of pages being used to store your data.

Changed = the # of pages that have been modified as a result of your
most recent vacuum.

Empty = pages containing no "live" tuples

Tup = # of "rows" in your table

Vac = # of dead tuples recovered

Keep = # of tuples that the db did not feel it could safely mark/remove
(probably envolved in some type of transaction)

Unused = # of tuples awaiting being reused

elapsed time is the amount of time it took to deal with the given table

Robert Treat



Re: Vacuum explained

From
Tom Lane
Date:
Robert Treat <xzilla@users.sourceforge.net> writes:
> Tup = # of "rows" in your table

Right.  This is the number of rows remaining after the vacuum, to be
precise.

> Keep = # of tuples that the db did not feel it could safely mark/remove
> (probably envolved in some type of transaction)

More specifically, these are tuples that are committed dead, but cannot
yet be removed because they might still be visible under the MVCC rules
to one or more open transactions.  This number is included in "Tup".

> Unused = # of tuples awaiting being reused

These are not actually tuples, but tuple slots (page item pointers)
that are open for re-use.

            regards, tom lane

Re: Vacuum explained -> Dangerous ?

From
"Gaetano Mendola"
Date:
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:26423.1041885959@sss.pgh.pa.us...
> Robert Treat <xzilla@users.sourceforge.net> writes:
> > Tup = # of "rows" in your table
>
> Right.  This is the number of rows remaining after the vacuum, to be
> precise.
>
> > Keep = # of tuples that the db did not feel it could safely mark/remove
> > (probably envolved in some type of transaction)


NOTICE:  Pages 2518: Changed 38, Empty 0; Tup 75489: Vac 447, Keep 68661,
UnUsed 144574.

This mean that if a process do a "begin transaction" and stay there one
month without
activity all row delete or updated after that "begin transaction" remain
there for ever ?
If it's so, this is what is happening on my DB I have a pool of process (
for performance
sake) and some of this process are not working but the first thing done is:

SetAutoCommit( false );

if this start the transaction ( I'm going to investigate ) is a disaster!!!!

Some one have already experience on that ?


Ciao
Gaetano.



Re: Vacuum explained -> Dangerous ?

From
Tom Lane
Date:
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> This mean that if a process do a "begin transaction" and stay there one
> month without
> activity all row delete or updated after that "begin transaction" remain
> there for ever ?

Actually not, because the transaction does not start internally
(MyProc->xmin doesn't get set) until its first real statement begins.
However, if you do something like
    begin;
    select 2+2;
and *then* go to sleep for a long time, then yes you will block vacuum
from reclaiming space.

Also, I believe the value of now() is frozen when you say "begin",
so I'd still say it's not good practice to "begin" until you're ready to
actually do something ...

            regards, tom lane

Re: Vacuum explained

From
Tilo Schwarz
Date:
Tom Lane writes:

> > Unused = # of tuples awaiting being reused
>
> These are not actually tuples, but tuple slots (page item pointers)
> that are open for re-use.

Maybe this is a good place to ask this: How do you actually reuse a tuple (or
the space the tuple needed on disk) if the number of bytes needed to store a
new tuple depends on the number of non null columns, the variable length
columns etc. (If I understood the documentation right, you store the tuples
within a page packed, i.e. variable length tuples are stored one after the
other, sometimes with alignment between the tuple header and the tuple data.)

Do you try to reuse tuples with a similar storage size (or something like
that) to prevent fragmentation or don't you have fragmentation by design (and
I miss something).

Any pointers to documentation or into the source code are welcome!

Regards,

    Tilo Schwarz

Re: Vacuum explained

From
Tom Lane
Date:
Tilo Schwarz <mail@tilo-schwarz.de> writes:
> Do you try to reuse tuples with a similar storage size (or something like
> that)

No.  If we try to put a tuple on a page, and there's room there, we'll
store it.  There is no intra-page fragmentation problem because we can
always reshuffle the tuples on a particular page --- this is what the
"page item pointer" overhead buys us.

Also, since any given file only holds tuples of a particular table,
there's already some degree of size-similarity present.  This gets
pretty weak if some of the fields are of widely varying length, of
course, but I'm dubious that there's much gold to be mined by thinking
harder about which page we put a tuple on...

> Any pointers to documentation or into the source code are welcome!

The comments at the head of src/include/storage/bufpage.h might be
illuminating.  Also see
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/page.html

            regards, tom lane