How well does PostgreSQL work with NULL values?

Question

PostgreSQL

As far as I know, at least in the past, MySQL had problems with NULL - queries with it were slow to process. Does Postgres have this problem? Perhaps it makes sense to use 0 or "" where possible?
Thank you.

Answer 1

Null does not affect performance. Performance was affected by indexing, before 8.2 b-tree in postgres was not able to index null values. If you suddenly want to use any other indexing algorithm, then it looks like you should refrain from using null
www.postgresql.org/docs/9.3/interactive/indexes-ty...
stackoverflow.com/questions/1222314/does-setting-n. ..