Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #9757: Why reclaim index deleted pages need twice vacuum - Mailing list pgsql-bugs

From digoal@126.com
Subject Re: BUG #9757: Why reclaim index deleted pages need twice vacuum
Date
Msg-id 201403311525500340585@126.com
Whole thread Raw
In response to BUG #9757: Why reclaim index deleted pages need twice vacuum  (digoal@126.com)
List pgsql-bugs
Tree view 
VGhhbmtzIHZlcnkgbXVjaCwgYnV0IGluIHJhcmUgY29uZGl0aW9uLCBpdCdzIGEgc21hbGwgdHJv
dWJsZS4NCg0KDQoNCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tDQrlhaznm4rmmK/kuIDovojlrZDnmoTkuossIEknbSBEaWdvYWwg
LCBKdXN0IERvIGl077yBDQrlvrflk6UoRGlnb2FsLlpob3UpDQrmlbDmja7lupPmioDmnK/nu4/n
kIYNCioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqDQrmna3l
t57mlq/lh6/nvZHnu5znp5HmioDmnInpmZDlhazlj7gNCuadreW3nuW4gue0q+iNhuiKsei3rzLl
j7fogZTlkIjlpKfljqZC5bqnMTHlsYINCumCrue8ljogICAzMTAwMTMNCuaJi+acujogICArODYg
MTM0ODQwMjE5NTMNCuW6p+acujogICArODYgNTcxIDg5NzEwOTQ4DQpRUTogICAgIDI3NjczMjQz
MQ0KZW1haWw6ICBkaWdvYWwuemhvdUBtb3BvLmNvbQ0KTVNOOiAgICB6enpxd2FyZUBob3RtYWls
LmNvbQ0KQmxvZzogaHR0cDovL2Jsb2cuMTYzLmNvbS9kaWdvYWxAMTI2Lw0KR2l0aHViOiBodHRw
czovL2dpdGh1Yi5jb20vZGlnb2FsDQoNCkZyb206IEhlaWtraSBMaW5uYWthbmdhcw0KRGF0ZTog
MjAxNC0wMy0zMSAxNDo1NA0KVG86IGRpZ29hbA0KQ0M6IHBnc3FsLWJ1Z3MNClN1YmplY3Q6IFJl
OiBbQlVHU10gQlVHICM5NzU3OiBXaHkgcmVjbGFpbSBpbmRleCBkZWxldGVkIHBhZ2VzIG5lZWQg
dHdpY2UgdmFjdXVtDQpPbiAwMy8yOC8yMDE0IDEwOjE1IEFNLCBkaWdvYWxAMTI2LmNvbSB3cm90
ZToNCj4gVGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOg0K
Pg0KPiBCdWcgcmVmZXJlbmNlOiAgICAgIDk3NTcNCj4gTG9nZ2VkIGJ5OiAgICAgICAgICBkaWdv
YWwuemhvdQ0KPiBFbWFpbCBhZGRyZXNzOiAgICAgIGRpZ29hbEAxMjYuY29tDQo+IFBvc3RncmVT
UUwgdmVyc2lvbjogOS4zLjMNCj4gT3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MgNi40IHg2NA0K
PiBEZXNjcmlwdGlvbjoNCj4NCj4gV2hlbiBJJ20gdGVzdGluZyBhIGluZGV4IHBhZ2UgcmVjeWNs
aW5nLCBmb3VuZCB0aGF0IHRoZSBpbmRleCBwYWdlIG11c3QgYmUNCj4gdHdvIHZhY3V1bSBjYW4g
YmUgcmV1c2VkLg0KDQpZZXAsIHRoYXQncyBob3cgdGhlIGItdHJlZSB3b3JrcyBbMV0uIEEgZGVs
ZXRlZCBwYWdlIGNhbm5vdCBiZSANCmltbWVkaWF0ZWx5IHJldXNlZCwgYmVjYXVzZSB0aGVyZSBt
aWdodCBiZSBjb25jdXJyZW50IHNjYW5zIHRoYXQgYXJlIA0KanVzdCBhYm91dCB0byB2aXNpdCB0
aGUgcGFnZS4gU28gd2hlbiBhIHBhZ2UgaXMgZGVsZXRlZCwgaS5lIHVubGlua2VkIA0KZnJvbSB0
aGUgdHJlZSwgaXQgaXMgc3RhbXBlZCB3aXRoIHRoZSBuZXh0IHRyYW5zYWN0aW9uIElELCBhbmQg
bGVmdCBpbiANCnBsYWNlLiBUaGUgbmV4dCB2YWN1dW0gY2hlY2tzIHRoYXQgdGhlIHRyYW5zYWN0
aW9uIElEIGlzIG5vIGxvbmdlciANCnZpc2libGUgdG8gYW55b25lLCB3aGljaCBlbnN1cmVzIHRo
YXQgdGhlcmUgYXJlIG5vIHRyYW5zYWN0aW9ucyBydW5uaW5nIA0KdGhhdCBtaWdodCd2ZSBzZWVu
IGEgcmVmZXJlbmNlIHRvIHRoYXQgcGFnZS4gT25seSBhZnRlciB0aGF0IHRoZSBwYWdlIA0KY2Fu
IGJlIHJldXNlZC4NCg0KVGhhdCdzIHF1aXRlIHBlc3NpbWFsOyBpbiBtb3N0IGNhc2VzIHRoZSBw
YWdlIGNvdWxkIGJlIHJldXNlZCBtdWNoIA0KZWFybGllciwgYmVjYXVzZSBpdCBpcyBhIHZlcnkg
dGlnaHQgd2luZG93IGZvciB2YWN1dW0gdG8gZGVsZXRlIGEgcGFnZSANCmp1c3Qgd2hlbiBhIGNv
bmN1cnJlbnQgc2NhbiBoYXMgcmVhZCBhIGxpbmsgdG8gdGhlIHBhZ2UgYW5kIGlzIGFib3V0IHRv
IA0KZm9sbG93IGl0LiBCdXQgQi10cmVlIHBhZ2VzIGFyZSB1c3VhbGx5IG5vdCBkZWxldGVkIHRo
YXQgb2Z0ZW4gdGhhdCBpdCANCndvdWxkIG1hdHRlciBpbiBwcmFjdGljZSwgc28gdGhlcmUgaGFz
IGJlZW4gbm8gZWZmb3J0IHRvIG9wdGltaXplIGl0Lg0KDQpJbiBzaG9ydCwgaXQncyBub3QgYSBi
dWcgOi0pLg0KDQpbMV0gDQpodHRwOi8vZ2l0LnBvc3RncmVzcWwub3JnL2dpdHdlYi8/cD1wb3N0
Z3Jlc3FsLmdpdDthPWJsb2I7Zj1zcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL1JFQURNRSNsMjgz
DQoNCi0gSGVpa2tp

pgsql-bugs by date:

Previous
From: info@gevnet.nl
Date:
Subject: BUG #9793: to_number wrong convertion
Next
From: "Samokhin, Dmitry [MNPP Saturn]"
Date:
Subject: Re: BUG #9756: Inconsistent database after OS restart