pageald

For our use case, we found the best approach was to clone all of the data to a temporary table with indices and constraints disabled, perform the updates, re-enable indices and constraints, and then replace the production table with the temporary table. This only works if you are able to update your data in bulk, and if some lag time in your updates is OK. This also has the benefit of never locking your production table.

In situations where real-time updates are important, the key is to minimize your indices as much as possible. Read up on heap only tuples (HOT). If that all isn't enough, maybe consider sharding your database.

Never run VACUUM FULL; it locks too aggressively. Let autovacuum do the job.

My first thought after reading the headline was that they had been placed under some kind of litigation hold and had to immediately back up all of their data on US customers to comply.

Just baseless speculation; I dont work for Facebook or have an inside source.

How does one find these high paying full time remote jobs? Most that I see with salaries listed on weworkremotely, Stack Overflow Jobs and the like top out around $150k.

There are lots of non-remote jobs that pay higher than my current salary, but I don't see that many remote jobs in the $180k to $200k range.

>(though maybe if marijuana becomes legal nationwide that will no longer be part of the test)

The test isn't going anywhere until there's a reliable field sobriety for weed. Companies don't want employees operating heavy equipment stoned, and unfortunately there's no way to test that somebody smoked in the last day or two, only that they've smoked in the last X weeks/months, depending on their habits.

It's code that provisions or configures VMs, containers, cloud resources like RDS, etc. Usually this is accomplished using tools like Terraform, Ansible playbooks, SaltStack, Kubernetes, and the many other similar tools.

Are there a lot of American expat software engineers in the UK? For most people, it would be a steep pay cut to move from the US to anywhere in the EU.

There is lots of truth to this, but it's not that hard to save up for 6 to 24 months of expenses on an engineer's salary, assuming you are living within your means. Dependents complicate the situation, but don't make it impossible.

My bank has a $100 minimum for transaction alerts. Sigh.

In my experience using AWS, you can spin up new autoscaled instances pretty quickly. I don't even have a custom AMI, I use a generic image and run startup scripts to kick off my server software. Takes < 3 minutes to spin up a new one and start accepting requests.

If that's not fast enough, you can bake an AMI and scale more proactively (e.g. scale when your server is 70% utilized rather than 95%)

Continuous Integration

Terrafirm isn't provider neutral. It is just a declarative wrapper for cloud provider APIs. Code using one provider is not easily translated to another.

I do think it's an excellent configuration management and provisioning tool, but Go Cloud solves a different problem.

Has there ever been a high profile early access game that crossed the finish line? It seems like studios usually take the money and run, like Bohemia Interactive with DayZ. Five years and tens/hundreds of millions of dollars in revenue and the game is abandonware.

I guess Minecraft is one notable exception.

Simulating millions of users should be well within the capabilities of a company as large as Amazon. Off the shelf load testing tools like Locust can create thousands of fake users with one worker.