parmindergarcha

7 ms·

1. 1.▲
   by parmindergarcha 1mo ago

   Location: London, England Remote : Yes Willing to relocate: No Technologies: PostgreSql, MariaDB, Golang, Python, Terraform, Kubernetes, Backend. Résumé/CV: Available on request. Email: parminder.garcha@outlook.com Database Engineer lo
2. 2.▲
   by parmindergarcha 2mo ago

   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 1000 - (default I think is 100), remember to run 'ANALYZ
3. 3.▲
   by parmindergarcha 2mo ago

   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 alternative to 'joins using case' and more likely to
4. 4.▲
   by parmindergarcha 3mo ago

   Location: London, England Remote : Yes Willing to relocate: No Technologies: PostgreSql, MariaDB, Golang, Python, Terraform, Kubernetes, Backend. Résumé/CV: Available on request. Email: parminder.garcha@outlook.com Database Engineer l