I read about STI (Single Table Inheritance) and like the idea.

Does PostgreSQL handle 95% NULL values in some columns if I have about 1M rows well?

Does it impact performance if there many columns (~70) and many of them contain mostly NULL values?

Infos about STI:

PS: unfortunately there is not tag for "STI" in this StackExchange site yer


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.