Re:Postgres Incremental Backup
by flockonus on Friday January 12, 2024 @12:47AM
(#38964421)
Glad I've learned about this fascinating effect, but it doesn't seem reasonable that such a niche improvement on Postgresql backup would have an impact on the price of electricity or another resource.
[ Parent
| on HN ]
No, but you could imagine a situation where a feature added to a database makes people more likely to use that database, even in places where maybe a "lighter weight" database (e.g. SQLite) would've been good enough, therefore increasing electricity usage overall.
Re:Postgres Incremental Backup
by peterfirefly on Friday January 12, 2024 @05:37AM
(#38966414)
That + many more people will take backups (and most of those will be unnecessary).
Still, imho, hardly the scale to have the effect visible, if you think how many servers exist vs. the electricity demand reduction.
One example I'd find reasonable, perhaps the Apple Silicon M family has a shot at it, when comparing the energy draw diff (less than half of Intel's equivalent) multiply by the adoption at scale.. maybe that.
One more straightforward that definitely have a chance at achieving the effect: LED lightbulbs: huge consumption reduction, huge scale.