Roberto Mello (@robertobmello) 's Twitter Profile
Roberto Mello

@robertobmello

Helping people, companies, systems, improve their reliability and performance. Love data. Long-time PostgreSQL guy. keybase.io/therbm

ID: 113961788

calendar_today13-02-2010 16:28:11

1,1K Tweet

445 Followers

1,1K Following

Crunchy Data (@crunchydata) 's Twitter Profile Photo

Running fast queries against large analytics tables is one of the hallmark features of Crunchy Data Warehouse. In this video: - a Iceberg file is created from a flat file - data is queried and rolled up by day, taking 38ms - the same rollup is done with the same data in

Roberto Mello (@robertobmello) 's Twitter Profile Photo

TIL you can set up a "read replica" Citus cluster with citus.use_secondary_nodes=always on the standby coordinator, but there's no automatic routing for read-only traffic.  That needs to be done by the app.

nixCraft 🐧 (@nixcraft) 's Twitter Profile Photo

AWS Deleted all data despite redundancy, backup, dead man’s switch. This is why you need to keep all your data offline. Never trust hosting company for your backups. seuros.com/blog/aws-delet…

Roberto Mello (@robertobmello) 's Twitter Profile Photo

Haven't needed to setup a Windows computer for a while. Microsoft now requires you to have an online account? And I have to install the "Microsoft 365 Copilot" app to login. Website is not enough and I need to download their website to my phone? Enishittification hard mode.

Mim (@mim_djo) 's Twitter Profile Photo

this is a great paper from snowflake, tl:dr; people (and tools) write very bad #SQL, my favorite which I did all the time is using joins on text field vldb.org/pvldb/vol18/p5…

Roberto Mello (@robertobmello) 's Twitter Profile Photo

Nice to see more and more people are getting this. Postgres’ flexibility and breadth of use cases it makes simpler is amazing.

Shaun Thomas (@bonesmoses) 's Twitter Profile Photo

If you use NPM in any capacity, you need to immediately perform a deep audit on your dependencies and probably revert to your previous lock file if you updated recently.