Vampy
@vampy.bsky.social
Reposted by Vampy
Was hacking on some more database stuff last night and put together a little blog post about some query optimizations I found using Materialized Common-Table Expressions in Postgres
Got a query from ~12s -> 0.12s by limiting as soon as possible.
https://jazco.dev/2023/08/10/query-optimization/
Got a query from ~12s -> 0.12s by limiting as soon as possible.
https://jazco.dev/2023/08/10/query-optimization/
Speeding Up Massive PostgreSQL Joins with Common Table Expressions
Instead, let’s structure the query as a Common Table Expression and leverage the power of doing significantly less work to make things go faster. Using a CTE instead of a naive full table join cuts ...
jazco.dev
August 11, 2023 at 7:16 PM
Was hacking on some more database stuff last night and put together a little blog post about some query optimizations I found using Materialized Common-Table Expressions in Postgres
Got a query from ~12s -> 0.12s by limiting as soon as possible.
https://jazco.dev/2023/08/10/query-optimization/
Got a query from ~12s -> 0.12s by limiting as soon as possible.
https://jazco.dev/2023/08/10/query-optimization/
Is that time of the year!
August 10, 2023 at 9:35 PM
Is that time of the year!
Reposted by Vampy
I wrote about the racist usernames found on Bluesky, obtained an email investors sent to the team, details about the personalized apologies from the company, and more.
https://fortune.com/2023/07/31/inside-bluesky-moderation-crisis-investor-pushback-user-backlash-ceo-apology/
https://fortune.com/2023/07/31/inside-bluesky-moderation-crisis-investor-pushback-user-backlash-ceo-apology/
Inside Bluesky CEO's 10 days of silence
Bluesky, the Twitter-rival, faced a crisis when a racist username went unchecked, leading to pressure from investors and users.
fortune.com
July 31, 2023 at 9:00 PM
I wrote about the racist usernames found on Bluesky, obtained an email investors sent to the team, details about the personalized apologies from the company, and more.
https://fortune.com/2023/07/31/inside-bluesky-moderation-crisis-investor-pushback-user-backlash-ceo-apology/
https://fortune.com/2023/07/31/inside-bluesky-moderation-crisis-investor-pushback-user-backlash-ceo-apology/
Reposted by Vampy
If you don’t promote yourself, no one is gonna do it for you. Fucking BRAG, tell the world about all the cool shit you’re doing, you’re smart and capable and I am proud of you bby
July 27, 2023 at 11:53 PM
If you don’t promote yourself, no one is gonna do it for you. Fucking BRAG, tell the world about all the cool shit you’re doing, you’re smart and capable and I am proud of you bby