Viewing profile — parmindergarcha

Location: London, England Remote : Yes Willing to relocate: No Technologies: PostgreSql, MariaDB, Golang, Python, Terraform, Kubernetes, Backend. Résumé/CV: Available on request. E…

If left joins are causing issues, maybe for a quick win try increasing the sample size on the column(s) involved e.g. ALTER TABLE tablename ALTER COLUMN columnname SET STATISTICS 1…

Noted that you only use this sparingly but you could try :- * Materialised views (especially if the computation/joins are particularly nasty). * Left outer joins are a good alterna…

Location: London, England Remote : Yes Willing to relocate: No Technologies: PostgreSql, MariaDB, Golang, Python, Terraform, Kubernetes, Backend. Résumé/CV: Available on request. E…