parmindergarcha

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 lots of experience within databases, comfortable coding, setting up entire backend database infrastructure from scratch.

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 'ANALYZE'.

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 use the index.

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 lots of experience within databases, comfortable coding, setting up entire backend database infrastructure from scratch.