Autovac vs manual with analyze

------=_Part_8405_12620711.1268677235839
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit



I've got about 44GB of data in a few hundred production databases. I'm using PG 8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I know. I wish it were, and it's slated here for q2, but I cannot even apply maintenance patches without a full testing cycle.

My auto-vac parameters are:
autovacuum = on # enable autovacuum subprocess?
autovacuum_naptime = 3 # time between autovacuum runs, in secs
autovacuum_vacuum_threshold = 400 # min # of tuple updates before vacuum
autovacuum_analyze_threshold = 200 # min # of tuple updates before analyze
autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
#autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for autovac

and auto-vacuum is running.

My problem is that each Saturday at midnight, I have to start a vacuumdb -f -z -a or my pg_clog dir never clears out.

The manual vacuum takes quite some time and impacts weekend customers.

So, my questions are:

a) Is the manual vacuum needed for performance reasons, or is auto-vac sufficient?
b) How do my settings look?
c) Is there a way that the clogs get cleared via autovac, would a full vac of just template1/template0 (if that last is possible) do it?



------=_Part_8405_12620711.1268677235839
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<=
div style=3D'font-family: Times New Roman; font-size: 12pt; color: #000000'=
>

pg_stop_backup()

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAC5DF.E184F0FA
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: base64

T3V0IG9mIGN1cmlvc2l0eSwgIGFueSBpZGVhIHdoeSBldmVyeSB0aW1lIEkg
cnVuIHNlbGVjdCBwZ19zdG9wX2JhY2t1cCgpOyAgaXQgZ29lcyBpbnRvIGFu
IGluZmluaXRlIGxvb3A/ICBXaGlsZSB0aGUgZmlyc3QgcGFydCBvZiB0aGlz
IHNlbGVjdCBwZ19zdGFydF9iYWNrdXAo4oCYbGFiZWzigJkpIHdvcmtzIHdp
dGhvdXQgYW55IGlzc3Vlcz8/DQoNCiANCg0KIA0KDQpWaXRhbHkgQnVyc2h0
ZXluDQoNClNlbmlvciBOZXR3b3JrIEVuZ2luZWVyDQoNCkJyb2Fkd2F5LmNv
bSwgVGhlYXRyZSBEaXJlY3QgSW50ZXJuYXRpb25hbA0KDQo3MjkgIDd0aCBB
dmVudWUNCg0KTmV3IFlvcmssIE5ldyBZb3JrIDEwMDE5DQoNClBob25lOiAy
MTIuODE3LjkxMTcNCg0KQ2VsbCMgOTE3LTcwMS01NzMyDQoNCiANCg0KCl9f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KVGhlIGluZm9y
bWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIHRyYW5zbWlzc2lvbiBtYXkgY29u
dGFpbiBwcml2aWxlZ2VkIA0KYW5kIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlv
bi4gIEl0IGlzIGludGVuZGVkIG9ubHkgZm9yIHRoZSB1c2Ugb2YgdGhlIA0K
cGVyc29uKHMpIG5hbWVkIGFib3ZlLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50
ZW5kZWQgcmVjaXBpZW50LCAgeW91IGFyZSANCmhlcmVieSBub3RpZmllZCB0
aGF0IGFueSByZXZpZXcsIGRpc3NlbWluYXRpb24sIGRpc3RyaWJ1dGlvbiBv
ciANCmR1cGxpY2F0aW9uIG9mIHRoaXMgY29tbXVuaWNhdGlvbiBpcyBzdHJp
Y3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgYXJlIA0Kbm90IHRoZSBpbnRlbmRl
ZCByZWNpcGllbnQsIHBsZWFzZSBjb250YWN0IHRoZSBzZW5kZXIgYnkgcmVw
bHkgZW1haWwgDQphbmQgZGVzdHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmln
aW5hbCBtZXNzYWdlLgo=

------_=_NextPart_001_01CAC5DF.E184F0FA
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwi
IHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9m
ZmljZSIgeG1sbnM6dz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZp
Y2U6d29yZCIgeG1sbnM6eD0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpv
ZmZpY2U6ZXhjZWwiIHhtbG5zOnA9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1j
b206b2ZmaWNlOnBvd2VycG9pbnQiIHhtbG5zOmE9InVybjpzY2hlbWFzLW1p
Y3Jvc29mdC1jb206b2ZmaWNlOmFjY2VzcyIgeG1sbnM6ZHQ9InV1aWQ6QzJG
NDEwMTAtNjVCMy0xMWQxLUEyOUYtMDBBQTAwQzE0ODgyIiB4bWxuczpzPSJ1
dWlkOkJEQzZFM0YwLTZEQTMtMTFkMS1BMkEzLTAwQUEwMEMxNDg4MiIgeG1s
bnM6cnM9InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206cm93c2V0IiB4bWxu
czp6PSIjUm93c2V0U2NoZW1hIiB4bWxuczpiPSJ1cm46c2NoZW1hcy1taWNy
b3NvZnQtY29tOm9mZmljZTpwdWJsaXNoZXIiIHhtbG5zOnNzPSJ1cm46c2No
ZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTpzcHJlYWRzaGVldCIgeG1sbnM6
Yz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6Y29tcG9uZW50
OnNwcmVhZHNoZWV0IiB4bWxuczpvZGM9InVybjpzY2hlbWFzLW1pY3Jvc29m
dC1jb206b2ZmaWNlOm9kYyIgeG1sbnM6b2E9InVybjpzY2hlbWFzLW1pY3Jv
c29mdC1jb206b2ZmaWNlOmFjdGl2YXRpb24iIHhtbG5zOmh0bWw9Imh0dHA6
Ly93d3cudzMub3JnL1RSL1JFQy1odG1sNDAiIHhtbG5zOnE9Imh0dHA6Ly9z
Y2hlbWFzLnhtbHNvYXAub3JnL3NvYXAvZW52ZWxvcGUvIiB4bWxuczpydGM9
Imh0dHA6Ly9taWNyb3NvZnQuY29tL29mZmljZW5ldC9jb25mZXJlbmNpbmci
IHhtbG5zOkQ9IkRBVjoiIHhtbG5zOlJlcGw9Imh0dHA6Ly9zY2hlbWFzLm1p
Y3Jvc29mdC5jb20vcmVwbC8iIHhtbG5zOm10PSJodHRwOi8vc2NoZW1hcy5t
aWNyb3NvZnQuY29tL3NoYXJlcG9pbnQvc29hcC9tZWV0aW5ncy8iIHhtbG5z
OngyPSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS9leGNl
bC8yMDAzL3htbCIgeG1sbnM6cHBkYT0iaHR0cDovL3d3dy5wYXNzcG9ydC5j
b20vTmFtZVNwYWNlLnhzZCIgeG1sbnM6b2lzPSJodHRwOi8vc2NoZW1hcy5t
aWNyb3NvZnQuY29tL3NoYXJlcG9pbnQvc29hcC9vaXMvIiB4bWxuczpkaXI9
Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vc2hhcmVwb2ludC9zb2Fw
L2RpcmVjdG9yeS8iIHhtbG5zOmRzPSJodHRwOi8vd3d3LnczLm9yZy8yMDAw
LzA5L3htbGRzaWcjIiB4bWxuczpkc3A9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jv
c29mdC5jb20vc2hhcmVwb2ludC9kc3AiIHhtbG5zOnVkYz0iaHR0cDovL3Nj
aGVtYXMubWljcm9zb2Z0LmNvbS9kYXRhL3VkYyIgeG1sbnM6eHNkPSJodHRw
Oi8vd3d3LnczLm9yZy8yMDAxL1hNTFNjaGVtYSIgeG1sbnM6c3ViPSJodHRw
Oi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL3NoYXJlcG9pbnQvc29hcC8yMDAy
LzEvYWxlcnRzLyIgeG1sbnM6ZWM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDEv
MDQveG1sZW5jIyIgeG1sbnM6c3A9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29m
dC5jb20vc2hhcmVwb2ludC8iIHhtbG5zOnNwcz0iaHR0cDovL3NjaGVtYXMu
bWljcm9zb2Z0LmNvbS9zaGFyZXBvaW50L3NvYXAvIiB4bWxuczp4c2k9Imh0
dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3RhbmNlIiB4bWxu
czp1ZGNzPSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2RhdGEvdWRj
L3NvYXAiIHhtbG5zOnVkY3hmPSJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQu
Y29tL2RhdGEvdWRjL3htbGZpbGUiIHhtbG5zOnVkY3AycD0iaHR0cDovL3Nj
aGVtYXMubWljcm9zb2Z0LmNvbS9kYXRhL3VkYy9wYXJ0dG9wYXJ0IiB4bWxu
czp3Zj0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9zaGFyZXBvaW50
L3NvYXAvd29ya2Zsb3cvIiB4bWxuczpkc3NzPSJodHRwOi8vc2NoZW1hcy5t
aWNyb3NvZnQuY29tL29mZmljZS8yMDA2L2RpZ3NpZy1zZXR1cCIgeG1sbnM6
ZHNzaT0iaHR0cDovL3NjaGVtYXMubWljcm9zb2Z0LmNvbS9vZmZpY2UvMjAw
Ni9kaWdzaWciIHhtbG5zOm1kc3NpPSJodHRwOi8vc2NoZW1hcy5vcGVueG1s
Zm9ybWF0cy5vcmcvcGFja2FnZS8yMDA2L2RpZ2l0YWwtc2lnbmF0dXJlIiB4
bWxuczptdmVyPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcv
bWFya3VwLWNvbXBhdGliaWxpdHkvMjAwNiIgeG1sbnM6bT0iaHR0cDovL3Nj
aGVtYXMubWljcm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxu
czptcmVscz0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL3Bh
Y2thZ2UvMjAwNi9yZWxhdGlvbnNoaXBzIiB4bWxuczpzcHdwPSJodHRwOi8v
bWljcm9zb2Z0LmNvbS9zaGFyZXBvaW50L3dlYnBhcnRwYWdlcyIgeG1sbnM6
ZXgxMnQ9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vZXhjaGFuZ2Uv
c2VydmljZXMvMjAwNi90eXBlcyIgeG1sbnM6ZXgxMm09Imh0dHA6Ly9zY2hl
bWFzLm1pY3Jvc29mdC5jb20vZXhjaGFuZ2Uvc2VydmljZXMvMjAwNi9tZXNz
YWdlcyIgeG1sbnM6cHB0c2w9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5j
b20vc2hhcmVwb2ludC9zb2FwL1NsaWRlTGlicmFyeS8iIHhtbG5zOnNwc2w9
Imh0dHA6Ly9taWNyb3NvZnQuY29tL3dlYnNlcnZpY2VzL1NoYXJlUG9pbnRQ
b3J0YWxTZXJ2ZXIvUHVibGlzaGVkTGlua3NTZXJ2aWNlIiB4bWxuczpaPSJ1
cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOiIgeG1sbnM6c3Q9IiYjMTsiIHht
bG5zPSJodHRwOi8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCg0KPGhl
YWQ+DQo8bWV0YSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0
ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1ldGEgbmFtZT1HZW5lcmF0
b3IgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTIgKGZpbHRlcmVkIG1lZGl1
bSkiPg0KPHN0eWxlPg0KPCEtLQ0KIC8qIEZvbnQgRGVmaW5pdGlvbnMgKi8N
CiBAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5OiJDYW1icmlhIE1hdGgiOw0K
CXBhbm9zZS0xOjIgNCA1IDMgNSA0IDYgMyAyIDQ7fQ0KQGZvbnQtZmFjZQ0K
CXtmb250LWZhbWlseTpDYWxpYnJpOw0KCXBhbm9zZS0xOjIgMTUgNSAyIDIg
MiA0IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q29uc29s
YXM7DQoJcGFub3NlLTE6MiAxMSA2IDkgMiAyIDQgMyAyIDQ7fQ0KIC8qIFN0
eWxlIERlZmluaXRpb25zICovDQogcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1h
bCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0
b206LjAwMDFwdDsNCglmb250LXNpemU6MTIuMHB0Ow0KCWZvbnQtZmFtaWx5
OiJUaW1lcyBOZXcgUm9tYW4iLCJzZXJpZiI7fQ0KYTpsaW5rLCBzcGFuLk1z
b0h5cGVybGluaw0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29sb3I6
Ymx1ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCmE6dmlzaXRl
ZCwgc3Bhbi5Nc29IeXBlcmxpbmtGb2xsb3dlZA0KCXttc28tc3R5bGUtcHJp
b3JpdHk6OTk7DQoJY29sb3I6cHVycGxlOw0KCXRleHQtZGVjb3JhdGlvbjp1
bmRlcmxpbmU7fQ0KcA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJbWFy
Z2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJZm9udC1zaXpl
OjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIiwic2Vy
aWYiO30NCnNwYW4ub2JqZWN0DQoJe21zby1zdHlsZS1uYW1lOm9iamVjdDt9
DQpzcGFuLkVtYWlsU3R5bGUxOQ0KCXttc28tc3R5bGUtdHlwZTpwZXJzb25h
bC1yZXBseTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYi
Ow0KCWNvbG9yOiMxRjQ5N0Q7fQ0KLk1zb0NocERlZmF1bHQNCgl7bXNvLXN0
eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1zaXplOjEwLjBwdDt9DQpA
cGFnZSBTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsNCgltYXJnaW46
MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2LlNlY3Rpb24xDQoJe3Bh
Z2U6U2VjdGlvbjE7fQ0KLS0+DQo8L3N0eWxlPg0KPCEtLVtpZiBndGUgbXNv
IDldPjx4bWw+DQogPG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3Bp
ZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2VuZGlmXS0tPjwhLS1baWYgZ3Rl
IG1zbyA5XT48eG1sPg0KIDxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4N
CiAgPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQogPC9vOnNo
YXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPg0KPC9oZWFkPg0KDQo8Ym9k
eSBsYW5nPUVOLVVTIGxpbms9Ymx1ZSB2bGluaz1wdXJwbGU+DQoNCjxkaXYg
Y2xhc3M9U2VjdGlvbjE+DQoNCjxwIGNsYXNzPU1zb05vcm1hbCBzdHlsZT0n
bXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0
OmF1dG8nPjxzcGFuDQpzdHlsZT0nZm9udC1zaXplOjExLjBwdDtmb250LWZh
bWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiJz5PdXQgb2YgY3VyaW9zaXR5
LCA8L3NwYW4+Jm5ic3A7YW55DQppZGVhIHdoeSBldmVyeSB0aW1lIEkgcnVu
IHNlbGVjdCBwZ19zdG9wX2JhY2t1cCgpOyAmbmJzcDtpdCBnb2VzIGludG8g
YW4NCmluZmluaXRlIGxvb3A/Jm5ic3A7IFdoaWxlIHRoZSBmaXJzdCBwYXJ0
IG9mIHRoaXMgc2VsZWN0DQpwZ19zdGFydF9iYWNrdXAo4oCYbGFiZWzigJkp
IHdvcmtzIHdpdGhvdXQgYW55IGlzc3Vlcz8/PG86cD48L286cD48L3A+DQoN
CjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBzdHlsZT0nZm9udC1zaXplOjEx
LjBwdDtmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2VyaWYiOw0KY29s
b3I6IzFGNDk3RCc+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KDQo8
cCBjbGFzcz1Nc29Ob3JtYWw+PHNwYW4gc3R5bGU9J2ZvbnQtc2l6ZToxMS4w
cHQ7Zm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjsNCmNvbG9y
OiMxRjQ5N0QnPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCg0KPGRp
dj4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFuIHN0eWxlPSdmb250LXNp
emU6MTAuNXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFzOw0KY29sb3I6IzFGNDk3
RCc+Vml0YWx5IEJ1cnNodGV5bjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCg0K
PHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFuIHN0eWxlPSdmb250LXNpemU6MTAu
NXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFzOw0KY29sb3I6IzFGNDk3RCc+U2Vu
aW9yIE5ldHdvcmsgRW5naW5lZXI8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQoN
CjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBzdHlsZT0nZm9udC1zaXplOjEw
LjVwdDtmb250LWZhbWlseTpDb25zb2xhczsNCmNvbG9yOiMxRjQ5N0QnPkJy
b2Fkd2F5LmNvbSwgVGhlYXRyZSBEaXJlY3QgSW50ZXJuYXRpb25hbDxvOnA+
PC9vOnA+PC9zcGFuPjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFu
IHN0eWxlPSdmb250LXNpemU6MTAuNXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFz
Ow0KY29sb3I6IzFGNDk3RCc+NzI5Jm5ic3A7IDd0aCBBdmVudWU8bzpwPjwv
bzpwPjwvc3Bhbj48L3A+DQoNCjxwIGNsYXNzPU1zb05vcm1hbD48c3BhbiBz
dHlsZT0nZm9udC1zaXplOjEwLjVwdDtmb250LWZhbWlseTpDb25zb2xhczsN
CmNvbG9yOiMxRjQ5N0QnPk5ldyBZb3JrLCBOZXcgWW9yayAxMDAxOTxvOnA+
PC9vOnA+PC9zcGFuPjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFu
IHN0eWxlPSdmb250LXNpemU6MTAuNXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFz
Ow0KY29sb3I6IzFGNDk3RCc+UGhvbmU6IDIxMi44MTcuOTExNzxvOnA+PC9v
OnA+PC9zcGFuPjwvcD4NCg0KPHAgY2xhc3M9TXNvTm9ybWFsPjxzcGFuIHN0
eWxlPSdmb250LXNpemU6MTAuNXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFzOw0K
Y29sb3I6IzFGNDk3RCc+Q2VsbCMgOTE3LTcwMS01NzMyPC9zcGFuPjxzcGFu
IHN0eWxlPSdmb250LXNpemU6MTEuMHB0Ow0KZm9udC1mYW1pbHk6IkNhbGli
cmkiLCJzYW5zLXNlcmlmIjtjb2xvcjojMUY0OTdEJz48bzpwPjwvbzpwPjwv
c3Bhbj48L3A+DQoNCjwvZGl2Pg0KDQo8ZGl2Pg0KDQo8ZGl2Pg0KDQo8ZGl2
Pg0KDQo8cCBjbGFzcz1Nc29Ob3JtYWwgc3R5bGU9J21hcmdpbi1ib3R0b206
MTIuMHB0Jz48c3BhbiBzdHlsZT0nY29sb3I6YmxhY2snPjxvOnA+Jm5ic3A7
PC9vOnA+PC9zcGFuPjwvcD4NCg0KPC9kaXY+DQoNCjwvZGl2Pg0KDQo8L2Rp
dj4NCg0KPC9kaXY+DQoNCgo8L2JvZHk+DQoNCjwvaHRtbD4NCg==

------_=_NextPart_001_01CAC5DF.E184F0FA--

Re: pg_stop_backup()

Vitaly Burshteyn wrote:
> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop? While the
> first part of this select pg_start_backup(?label?) works without
> any issues??

pg_start_backup() is waiting for the archives to be stored. I would
look in the server logs to see if something if failing there. 9.0 will
have better feedback when pg_stop_backup hangs like that.

--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com

PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: pg_stop_backup()

On Wed, 2010-03-17 at 10:41 -0400, Vitaly Burshteyn wrote:

> Out of curiosity, any idea why every time I run select
> pg_stop_backup(); it goes into an infinite loop?

When you say "infinite" do you mean to say it never comes out of the
loop at all? Not sure if you are reporting a bug, or not.

The manual describes what is happening:
http://developer.postgresql.org/pgdocs/postgres/continuous-a rchiving.html#BACKUP-BASE-BACKUP
Step 5

Is there anything you think should be added to the manual?

--
Simon Riggs www.2ndQuadrant.com


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Autovac vs manual with analyze

On Mon, 2010-03-15 at 13:20 -0500, Scott Whitney wrote:

> My problem is that each Saturday at midnight, I have to start a
> vacuumdb -f -z -a or my pg_clog dir never clears out.

Why is your pg_clog dir a problem?

> So, my questions are:
>
> a) Is the manual vacuum needed for performance reasons, or is auto-vac
> sufficient?

If you don't know why you are running it, then you should skip it and
measure the difference.

--
Simon Riggs www.2ndQuadrant.com


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin