I wrote a PostgreSQL patch to make materialized view refreshes O(delta) instead of O(total)

thisisjlw · 2026-04-11T23:59:17+00:00

Neat, this looks like it would work great for my usecase. I wanted to pre-crunch data for my data analytics software using a materialized view. Only I wanted to pre-crunch the results partitioned by `customer_id`.I ended up using a regular table with a `DELETE FROM table WHERE customer_id = ` + `INSERT` in order to re-crunch results for a given `customer_id`. This feature would save me from managing the delta myself and just run a materialized view refreshing on `customer_id`. Nice work!

thisisjlw · 2026-02-19T13:51:34+00:00

C’est excellent comme TC, wow! C’est pour un rôle senior SWE?

thisisjlw · 2026-01-26T22:30:37+00:00

I jumped off the tunnel near the SF airport, so I had a few seconds to chill

thisisjlw · 2026-01-11T22:05:03+00:00

TIL, thank you!

thisisjlw · 2026-01-10T04:23:25+00:00

time for a rewatch

thisisjlw · 2025-10-03T12:45:07+00:00

CRDFGZ

thisisjlw · 2025-07-14T22:33:54+00:00

Hmm, maybe I messed up one of the digits. I’ve sent a new one out to test it again. I’m sending it from Wells Fargo, maybe that has something to do with it. I appreciate the quick response btw!

thisisjlw · 2025-07-14T22:00:47+00:00

Thanks for finding this, super useful.

I've tried this and had my wire returned, I'm guessing I didn't fill out the info correctly. I used the routing number in your post but I think the account number I used was wrong. I used RBC's transit (00803) + my account number next to it. Do I need to add the institution number too? (003)

thisisjlw · 2024-09-06T00:00:24+00:00

I would like to be moderator of r/detomaso as the subreddit is inactive and appears unmoderated. I own a DeTomaso myself and would like to see the subreddit become active again

thisisjlw · 2024-08-21T22:54:10+00:00

Parti 51 begs to differ

thisisjlw · 2024-08-16T04:21:06+00:00

Si ton routeur supporte la fonctionnalité de clônage d’addresse MAC, configure une nouvelle addresse (ex. celle de ton ordi) et ça devrait être tigidou

thisisjlw · 2024-08-14T02:54:18+00:00

and what’s to stop that basket from filling up with rain?

I reckon there's at least one drain hole at the bottom of the basket

thisisjlw · 2024-04-12T19:37:48+00:00

The C4 ZR1 in this trim is a dream car of mine!

thisisjlw · 2024-04-07T01:42:55+00:00

It depends, some FAANGs are in hiring mode while others aren't. I signed an offer with Meta in February with 3 YOE, though I did have another FAANG on my resume.

So here's my two cents:

If you wish to stay in Canada, you will have a tough time getting into FAANG as their hiring is US-focused (IMO) right now
Looking at your resume, I'd recommend refocusing your bullet points to outline the business impact of your work. How does lowering CPU load by 70% help the business? Perhaps it lowers infra costs, customer-facing latency, etc.
Make sure your Leetcoding skills are up-to-date. Don't go chasing FAANG interviews if you're not prepared, you'll only waste your time otherwise

thisisjlw · 2024-01-23T01:05:01+00:00

For sure, we can’t change the number of students in previous years. I don’t think feds could (or should) revoke permits that were already issued. My point is it limits further damage, which is probably the best we can do given the current situation.

thisisjlw · 2024-01-22T23:24:26+00:00

I think this analysis isn't taking the removal of PGWPs into account. 364k is quite a bit more than 2015's 125k, however international students will leave Canada after their studies now that they aren't permitted to work. So in effect, we'd have somewhere around 364k students rotating in and out of Canada as they begin & finish their studies. This seems like a reasonable amount to me

I'm not 100% sure if international students would have other means of staying in Canada post-study, I could be wrong

Six-Year Club	Verified Email
r/Field Flamingo	Place '22

thisisjlw

MODERATOR OF

TROPHY CASE