I added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.
@mh2333.bsky.social
@mh2333.bsky.socialI added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.
@jobboardsearch.com📢 Fidelity International is #hiring a Technical Data Analyst!
🌎
⏰ Generous parental leave
#jobalert #jobsearch #JobSeekers #4dayworkweek #python #aws #dataengineer #sql #design
@jobboardsearch.com📢 Fidelity International is #hiring a SI Solutions - Analyst, Proxy Voting!
🌎
⏰ Generous parental leave
#jobalert #jobsearch #JobSeekers #4dayworkweek #python #sql #finance
@jobboardsearch.com📢 Compassx is #hiring a Technical Architect (Oracle EBS)!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #oracle #sql #design
@jobboardsearch.com📢 Centers For Disease Control And Prevention is #hiring a Epidemiologist!
🌎 Atlanta, Georgia, United States
#jobalert #jobsearch #familyofficejobs #python #php #sql #design
@jobboardsearch.com📢 Gopuff is #hiring a Software Engineer, Tech Lead - Supply Chain!
💰 $160K - $225K
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #javascript #softwareengineer #azure #golang #sql #terraform #design
@jobboardsearch.com📢 Action 1 is #hiring a Development Manager - Integrations!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #nodejs #javascript #aws #softwareengineer #typescript #sql #design
@jobboardsearch.com📢 Action 1 is #hiring a Development Manager - Integrations!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #nodejs #javascript #aws #softwareengineer #typescript #sql #design
@jobboardsearch.com📢 Skylight is #hiring a Senior Analytics Engineer (Finance & Operations)!
💰 $150K - $170K
🌎 Worldwide
👵 Senior
#jobalert #jobsearch #remotejob #remotework #wfh #aws #sql #design #finance
@jobboardsearch.com📢 Mpf Federal is #hiring a Senior Epidemiologist!
🌎 San Diego, California, United States
👵 Senior
#jobalert #jobsearch #familyofficejobs #python #machinelearning #sql #design
@jobboardsearch.com📢 Motive is #hiring a Business Strategy & Operations Manager, Networks!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #sql #marketing #finance
@jobboardsearch.com📢 City Of New York is #hiring a Senior Drug Checking Epidemiologist, Bureau Of Alcohol And Drug Use!
🌎 Long Island City, New York, United States
👵 Senior
@jobboardsearch.com📢 Action 1 is #hiring a Development Manager - Integrations!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #nodejs #javascript #aws #softwareengineer #typescript #sql #design
@jobboardsearch.com📢 Action 1 is #hiring a Development Manager - Integrations!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #nodejs #javascript #aws #softwareengineer #typescript #sql #design
@jobboardsearch.com📢 Action 1 is #hiring a Development Manager - Integrations!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #nodejs #javascript #aws #softwareengineer #typescript #sql #design
@jobboardsearch.com📢 Sequen Ai is #hiring a Gtm Engineer!
🌎
@jobboardsearch.com📢 Roo is #hiring a Full Stack Engineer!
💰 $150K - $195K
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #javascript #backend #aws #softwareengineer #fullstack #typescript #devops #sql #design
@jobboardsearch.com📢 Motive is #hiring a Business Strategy & Operations Manager!
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #sql #design #finance
@jobboardsearch.com📢 Wisetack is #hiring a Financial Operations Analyst Ii, Treasury!
🌎
#jobalert #jobsearch #remotejobs #python #dataengineer #sql #design #finance
@jobboardsearch.com📢 Nextdoor is #hiring a Data Scientist - Ads Marketplace!
💰 $153K - $208K
🌎 Worldwide
#jobalert #jobsearch #remotejob #remotework #wfh #python #machinelearning #sql #marketing #design #finance
