Hacker News new | ask | show | jobs
by manv1 1152 days ago
Really, a better solution might be to spew the results into another table and then schedule downtime and replace the original table (via rename or whatever).

It all depends on your database, which is why you need an actual DBA role on your team instead of just using your database like an abstract storage entity.
1 comments
alex_lav 1152 days ago
> It all depends on your database, which is why you need an actual DBA role on your team instead of just using your database like an abstract storage entity.

People seem to be getting along alright without it, no?

link
manv1 1152 days ago
That's true, but that's sort of suboptimal.

I mean ideally you would want someone on your team who understands how the technology behind your product actually works and how to use it efficiently.

"We built this awesome tower. The foundation? It's great so far, I guess. But we really are tower builders, not foundation builders." - The team behind the Leaning Tower of Pisa

The Leaning Tower stands today, so obviously they built their tower really well. But the problems with the foundation takes away from it somewhat.

link