RE: Disk space consumption: character varying(255) versus text used for index

--_000_DM6PR06MB488956DEB11A82EFC5DFEF91E52C0DM6PR06MB4889namp_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

SnVzdCB0byBtYWtlIGl0IGEgbGl0dGxlIG1vcmUgY2xlYXIsIFBvc3RncmVTUUwgaGFzIGEgYmlu
YXJ5IFVVSUQgdHlwZSB0aGF0IHNob3VsZCBob3VzZSB5b3VyIEdVSUTigJlzIHBlcmZlY3RseSBl
ZmZpY2llbnRseS4gKEl0IGFsc28gcHJvdmlkZXMgYSBsb3Qgb2Ygb3RoZXIgdXNlZnVsIGZ1bmN0
aW9uYWxpdHkgYW5kIHNwZWVkIGltcHJvdmVtZW50cyk6DQoNCmh0dHBzOi8vd3d3LnBvc3RncmVz
cWwub3JnL2RvY3MvMTIvZGF0YXR5cGUtdXVpZC5odG1sDQoNCg0KDQpGcm9tOiBKdXN0aW4gPHp6
enp6LmdyYWZAZ21haWwuY29tPg0KU2VudDogRnJpZGF5LCBEZWNlbWJlciAyMCwgMjAxOSAxMjow
NiBQTQ0KVG86IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4NCkNjOiBydWZmQG5ldHdha2Uu
Y29tOyBwZ3NxbC1ub3ZpY2VAcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBEaXNrIHNwYWNl
IGNvbnN1bXB0aW9uOiBjaGFyYWN0ZXIgdmFyeWluZygyNTUpIHZlcnN1cyB0ZXh0IHVzZWQgZm9y
IGluZGV4DQoNCkhhdmUgcXVlc3Rpb24gdGhpcyBzdGF0ZXMgdGhlIEdVSUQgIGlzIHRoZSB0ZXh0
IEhleCB2YWx1ZSBmb3JtIGEgVVVJRCAgaWYgc28gdGhhdCAzNmJ5dGVzIGxvbmcgIHZzIGludGVn
ZXIgdGhhdCBpcyAxMjhiaXRzICAgaWYgdGhhdCBpcyB0aGUgY2FzZSBjb252ZXJ0IHRoaXMgR1VJ
RCB0byAgVVVJRCB0eXBlDQoNCm9yIGFtIGkgbWlzc2luZyBzb21ldGhpbmc/DQoNCk9uIEZyaSwg
RGVjIDIwLCAyMDE5IGF0IDE6NTUgUE0gVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPG1haWx0
bzp0Z2xAc3NzLnBnaC5wYS51cz4+IHdyb3RlOg0KTWFyY2VsIFJ1ZmYgPHJ1ZmZAbmV0d2FrZS5j
b208bWFpbHRvOnJ1ZmZAbmV0d2FrZS5jb20+PiB3cml0ZXM6DQo+IG15IGJ0cmVlIGluZGV4IGZv
cg0KPiAgICBndWlkICAgICAgICAgICAgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcoMjU1KQ0KPiBp
cyBjdXJyZW50bHkgNi45R0IgKGFsbW9zdCBhbGwgZ3VpZCBlbnRyaWVzIGFyZSBvZiBzaXplIDM3
Ynl0ZXMpDQo+IElmIEkgd291bGQgY2hhbmdlIHRoZSBkYXRhIHR5cGUgdG8NCj4gICBndWlkICAg
ICAgICAgICAgICAgIHwgdGV4dA0KPiB3b3VsZCB0aGUgaW5kZXggc2l6ZSBiZSByZWR1Y2VkICh3
aXRob3V0IGhpdHRpbmcgcGVyZm9ybWFuY2UpPw0KDQpXb3VsZG4ndCBtYWtlIGFueSBkaWZmZXJl
bmNlIGF0IGFsbC4NCg0KICAgICAgICAgICAgICAgICAgICAgICAgcmVnYXJkcywgdG9tIGxhbmUN
Cg0K

--_000_DM6PR06MB488956DEB11A82EFC5DFEF91E52C0DM6PR06MB4889namp_
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv
ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl
PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6
IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m
YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy
IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws
IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ
Zm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQph
OmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv
cjpibHVlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFuLk1z
b0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjpwdXJw
bGU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpwLm1zb25vcm1hbDAsIGxpLm1zb25v
cm1hbDAsIGRpdi5tc29ub3JtYWwwDQoJe21zby1zdHlsZS1uYW1lOm1zb25vcm1hbDsNCgltc28t
bWFyZ2luLXRvcC1hbHQ6YXV0bzsNCgltYXJnaW4tcmlnaHQ6MGluOw0KCW1zby1tYXJnaW4tYm90
dG9tLWFsdDphdXRvOw0KCW1hcmdpbi1sZWZ0OjBpbjsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZv
bnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmO30NCnNwYW4uRW1haWxTdHlsZTE4DQoJe21z
by1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIixzYW5z
LXNlcmlmOw0KCWNvbG9yOndpbmRvd3RleHQ7fQ0KLk1zb0NocERlZmF1bHQNCgl7bXNvLXN0eWxl
LXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMtc2VyaWY7fQ0K
QHBhZ2UgV29yZFNlY3Rpb24xDQoJe3NpemU6OC41aW4gMTEuMGluOw0KCW1hcmdpbjoxLjBpbiAx
LjBpbiAxLjBpbiAxLjBpbjt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24x
O30NCi0tPjwvc3R5bGU+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWRlZmF1bHRz
IHY6ZXh0PSJlZGl0IiBzcGlkbWF4PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtp
ZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQo8bzppZG1h
cCB2OmV4dD0iZWRpdCIgZGF0YT0iMSIgLz4NCjwvbzpzaGFwZWxheW91dD48L3htbD48IVtlbmRp
Zl0tLT4NCjwvaGVhZD4NCjxib2R5IGxhbmc9IkVOLVVTIiBsaW5rPSJibHVlIiB2bGluaz0icHVy
cGxlIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5K
dXN0IHRvIG1ha2UgaXQgYSBsaXR0bGUgbW9yZSBjbGVhciwgUG9zdGdyZVNRTCBoYXMgYSBiaW5h
cnkgVVVJRCB0eXBlIHRoYXQgc2hvdWxkIGhvdXNlIHlvdXIgR1VJROKAmXMgcGVyZmVjdGx5IGVm
ZmljaWVudGx5LiAoSXQgYWxzbyBwcm92aWRlcyBhIGxvdCBvZiBvdGhlciB1c2VmdWwgZnVuY3Rp
b25hbGl0eSBhbmQgc3BlZWQgaW1wcm92ZW1lbnRzKTo8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+
PGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9kYXRhdHlwZS11dWlk
Lmh0bWwiPmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTIvZGF0YXR5cGUtdXVpZC5o
dG1sPC9hPjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8
L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxw
IGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05v
cm1hbCI+PGI+RnJvbTo8L2I+IEp1c3RpbiAmbHQ7enp6enouZ3JhZkBnbWFpbC5jb20mZ3Q7IDxi
cj4NCjxiPlNlbnQ6PC9iPiBGcmlkYXksIERlY2VtYmVyIDIwLCAyMDE5IDEyOjA2IFBNPGJyPg0K
PGI+VG86PC9iPiBUb20gTGFuZSAmbHQ7dGdsQHNzcy5wZ2gucGEudXMmZ3Q7PGJyPg0KPGI+Q2M6
PC9iPiBydWZmQG5ldHdha2UuY29tOyBwZ3NxbC1ub3ZpY2VAcG9zdGdyZXNxbC5vcmc8YnI+DQo8
Yj5TdWJqZWN0OjwvYj4gUmU6IERpc2sgc3BhY2UgY29uc3VtcHRpb246IGNoYXJhY3RlciB2YXJ5
aW5nKDI1NSkgdmVyc3VzIHRleHQgdXNlZCBmb3IgaW5kZXg8bzpwPjwvbzpwPjwvcD4NCjxwIGNs
YXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPGRpdj4NCjxkaXY+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIj5IYXZlIHF1ZXN0aW9uIHRoaXMgc3RhdGVzIHRoZSBHVUlEJm5ic3A7
IGlzIHRoZSB0ZXh0IEhleCB2YWx1ZSBmb3JtIGEgVVVJRCZuYnNwOyBpZiBzbyB0aGF0IDM2Ynl0
ZXMgbG9uZyZuYnNwOyB2cyBpbnRlZ2VyIHRoYXQgaXMgMTI4Yml0cyZuYnNwOyZuYnNwOyBpZiB0
aGF0IGlzIHRoZSBjYXNlIGNvbnZlcnQgdGhpcyBHVUlEIHRvJm5ic3A7IFVVSUQgdHlwZSZuYnNw
Ow0KPG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48
bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwi
Pm9yIGFtIGkgbWlzc2luZyBzb21ldGhpbmc/PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2
Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8ZGl2Pg0KPGRp
dj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPk9uIEZyaSwgRGVjIDIwLCAyMDE5IGF0IDE6NTUgUE0g
VG9tIExhbmUgJmx0OzxhIGhyZWY9Im1haWx0bzp0Z2xAc3NzLnBnaC5wYS51cyI+dGdsQHNzcy5w
Z2gucGEudXM8L2E+Jmd0OyB3cm90ZTo8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGJsb2NrcXVv
dGUgc3R5bGU9ImJvcmRlcjpub25lO2JvcmRlci1sZWZ0OnNvbGlkICNDQ0NDQ0MgMS4wcHQ7cGFk
ZGluZzowaW4gMGluIDBpbiA2LjBwdDttYXJnaW4tbGVmdDo0LjhwdDttYXJnaW4tcmlnaHQ6MGlu
Ij4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtYXJnaW4tYm90dG9tOjEyLjBwdCI+TWFy
Y2VsIFJ1ZmYgJmx0OzxhIGhyZWY9Im1haWx0bzpydWZmQG5ldHdha2UuY29tIiB0YXJnZXQ9Il9i
bGFuayI+cnVmZkBuZXR3YWtlLmNvbTwvYT4mZ3Q7IHdyaXRlczo8YnI+DQomZ3Q7IG15IGJ0cmVl
IGluZGV4IGZvcjxicj4NCiZndDsgJm5ic3A7Jm5ic3A7IGd1aWQmbmJzcDsmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz
cDsmbmJzcDsmbmJzcDsgfCBjaGFyYWN0ZXIgdmFyeWluZygyNTUpPGJyPg0KJmd0OyBpcyBjdXJy
ZW50bHkgNi45R0IgKGFsbW9zdCBhbGwgZ3VpZCBlbnRyaWVzIGFyZSBvZiBzaXplIDM3Ynl0ZXMp
PGJyPg0KJmd0OyBJZiBJIHdvdWxkIGNoYW5nZSB0aGUgZGF0YSB0eXBlIHRvPGJyPg0KJmd0OyAm
bmJzcDsgZ3VpZCZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyB8IHRleHQ8YnI+DQom
Z3Q7IHdvdWxkIHRoZSBpbmRleCBzaXplIGJlIHJlZHVjZWQgKHdpdGhvdXQgaGl0dGluZyBwZXJm
b3JtYW5jZSk/PGJyPg0KPGJyPg0KV291bGRuJ3QgbWFrZSBhbnkgZGlmZmVyZW5jZSBhdCBhbGwu
PGJyPg0KPGJyPg0KJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5i
c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgcmVnYXJkcywgdG9tIGxhbmU8
YnI+DQo8YnI+DQo8bzpwPjwvbzpwPjwvcD4NCjwvYmxvY2txdW90ZT4NCjwvZGl2Pg0KPC9kaXY+
DQo8L2JvZHk+DQo8L2h0bWw+DQo=

--_000_DM6PR06MB488956DEB11A82EFC5DFEF91E52C0DM6PR06MB4889namp_--