Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Great resource! I have used PostgeSQL since, well forever. And I didn’t know the advice on text storage. Shame on me, but now I know.


Agreed! The ORM I'm currently using has been setting text for all my `string` columns by default and I was feeling the need to go fix a few, so this is one of those magical times when procrastinating on an issue paid off in my favour.

On that note though, I wonder what impact (if any) this has on an index covering the column? I could be off here but from my mysql days I was under the impression the index would be more efficient if there was a length limit on the column.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: