News for hackers. Stuff that matters.
Re:Full text search in milliseconds with PostgreSQL by devmach on Friday May 08, 2015 @03:40PM (#9513706)
If I'm not mistaken: Altering a table can be costly and may cause a performance issues, specially if you have millions of records. Rows will be most likely locked and get updated and during this process other threads should wait until related row become "free".
Re:Full text search in milliseconds with PostgreSQL by ddorian43 on Friday May 08, 2015 @04:02PM (#9513821)
That only happens if you add a non-nullable column.