News for hackers. Stuff that matters.

A comment on Common mistakes in PostgreSQL. Parent comment

Re:Common mistakes in PostgreSQL by i_s on Friday May 03, 2019 @03:28PM (#19821472)
That's strange. In SQL Server, the size of the text columns impacts performance [0] by changing the amount of memory that is allocated to run queries.

[0] - https://sqlperformance.com/2017/06/sql-plan/performance-myth...

[ Parent | on HN ]
Re:Common mistakes in PostgreSQL by ben509 on Friday May 03, 2019 @03:47PM (#19821636)
As the article points out, that's not normally the case in SQL Server, it's that there are certain steps like sorting that require blocks of preallocated memory.

SQL Server is probably like that because varchar(max) is relatively recent; I'd expect as their support for it improves that issue will go away.

[ Parent | on HN ]