Viewing profile — JimNasby

More than 4 GW of capacity has gone offline in the last few minutes, based on http://www.ercot.com/content/cdr/html/real_time_system_condi... . A significant chunk of load was shed…

The grid has basically zero capability to change the voltage; frequency is all that matters. Frequency is so low that in the past hour any power line time base has fallen over 5.5 …

Out of curiosity, is it inheritance you like, or just the partitioning aspect of it? I've actually used inheritance far more than partitioning, but I know of others that would love…

Something that might be very interesting would be combining https://www.torodb.com/ with Timescale. ToroDB is database agnostic (though they prefer Postgres). If you extracted the …

Not sure what you're trying to say about "requires no extensions"; Timescale is an extension that doesn't modify Postgres itself, similar to Citus, and very different from XL/XC, G…

FWIW, I got the impression that they didn't truncate the table, but just forced an update to it's relfrozenxid to advance the freeze age and allow the database to restart. That mea…

I think the real takeaway here is that any part of your underlying technology that you don't thoroughly understand puts you at risk, and that risk goes up significantly in a large …

You need to monitor how close you are to a wraparound. https://bucardo.org/check_postgres/check_postgres.pl.html#tx... is one way you could do that.