"Simon Riggs" <[EMAIL PROTECTED]> writes: > Long text fields that might use LIKE should be set to 100. CHAR(1) and > general fields should be set to 10.
I could see arguing that either way. Longer fields are capable of more precision and so may need more buckets to predict. On the other hand longer fields take more space and take longer to compare so to make consistent use of resources you would want to avoid storing and comparing large numbers of them whereas you could afford much larger targets for small quick columns. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings