#energy

Posts tagged #energy

1. Question

   Storing high-frequency meter data: plain Postgres, TimescaleDB, or something else?

   We are getting more charger and meter data than our current setup was designed for. Right now it is about 40,000 devices sending a reading every 15 seconds, so roughly 230 million rows per day, into a single Postgres table with a B-tree index on (device_id, ts) . Inserts are still fine, but queries over a week for one site are getting slow and the table is huge. Typical queries: last 24 hours for one device, at full…

   Emma LindqvistSep 19, 20262likes3comments

2. Article

   Shifting batch jobs to cleaner hours: what actually moves the needle

   Our product shifts EV charging to the hours when the grid is cleaner, so naturally people on my team asked whether we do the same with our own batch jobs. We do now. Here is what I learned, including where the gains are smaller than the conference talks suggest. The basic idea Electricity is not equally clean every hour. When wind and solar are high, the grid mix has a lower carbon intensity (grams of CO2 per kWh).…

   Emma LindqvistAug 23, 20263likes4comments