ASIF ISLAM

Hustler!
SWE @catalyxspace.
0s and 1s of my profile arranged neatly here:

[ASIF ISLAM @Asifoff7]

https://t.co/JcrT6tQR7m

Check it out here☝️

[ASIF ISLAM @Asifoff7]

I try to make things simpler to understand and tell the world. These days you must have heard about CPU, GPU, TPU, NPU..
What's the actual difference and and why does AI need all of them to operate. wrote something for this. give this a read! Let me know what you think ! 👇👇

[ASIF ISLAM @Asifoff7]

MacBook outperforms windows by cutting the "data taxes" between GPU and CPU. Its important to learn the systems performance as a software engineer when you are building something. Give it a read.
https://t.co/TWarsGpof2

[ASIF ISLAM @Asifoff7]

@_devJNS 😂😂😂

[ASIF ISLAM @Asifoff7]

@nssdatta Lol, recession in X accounts growth !
Space is booming and our accounts are bleeding 😂

[ASIF ISLAM @Asifoff7]

@nssdatta give me some growth tips for X account 😂 !

[ASIF ISLAM @Asifoff7]

3/3
But every superpower has a cost.
Old row versions become "dead tuples".
Too many dead tuples =
- Index bloat
- Slower scans
- More storage usage
That's why PostgreSQL has VACUUM , the silent hero cleaning up behind the scenes.

[ASIF ISLAM @Asifoff7]

1/3
We saw that PostgreSQL separates the Index from the Heap.
But here's the twist.
When you UPDATE a row, Postgres doesn't overwrite the existing data.
Instead, it creates a NEW version of the row and keeps the old one around.
Wait... doesn't that waste storage?

[ASIF ISLAM @Asifoff7]

2/3
Not really.
This is PostgreSQL's MVCC (Multi-Version Concurrency Control).
Because old versions remain available:
- Readers don't block writers
- Writers don't block readers
It's one of the biggest reasons Postgres scales so well under concurrent workloads

[ASIF ISLAM @Asifoff7]

@nileshrthr @heyclicky Congratulations

[ASIF ISLAM @Asifoff7]

@nssdatta Sarkari naukri

[catalyx space @catalyxspace]

delta base, ahmedabad, loading...

[ASIF ISLAM @Asifoff7]

@heysaqh which party is Anthropic ?

[ASIF ISLAM @Asifoff7]

@wassaf_ali Congratulations ! same no on X soon.

[ASIF ISLAM @Asifoff7]

The way you shape and elevate the thinking of people around you is truly rare. SubhanAllah, it’s inspiring to witness and learn from it every day.
And like I always say, creativity speaks, and it’s clearly resonating through this video. Top-notch filmmaking 👏

[saqib hussain @heysaqh]

I turn 27 today.

By God's grace, in the last 18 months, we went from $0 to building a multi-million dollar space company.

But this isn't about that -- it's about the kid in you.

When we were young, we had big dreams. Rockets. Robots. Space. Pure and innocent.

But somewhere along the way, most of us stopped dreaming them.

The ones who didn't, did one of two things: changed the world, or are still trying to.
The world only celebrates the first kind.

But I've seen the second kind up close -- my team.

And though they haven't changed the world yet, they have one thing: contentment.

I've seen them work past midnight for weeks -- not for a paycheck, but to fulfill the dream they once had as kids.

Birthdays come once a year, but it's them who make every day feel special.

Thank you to each one of you. Thank you for being with @catalyxspace

And if you feel left behind; come join us. We have room for more dreamers.

yours truly,
Saqib

(also i'm getting older, faaah 🥹)

[ASIF ISLAM @Asifoff7]

A beautiful portrayal of grit and vision. Kudos to the filmmakers for capturing our founder's story so authentically. Truly inspiring !

[catalyx space @catalyxspace]

Most founders start in a garage.
We started on a rooftop.

Just an idea, some hardware, and 0 money.
7 months later, we launched a spacecraft.

This is that story.

[ASIF ISLAM @Asifoff7]

@abhitwt 3000

[ASIF ISLAM @Asifoff7]

So what’s the trade-off?
Flexible, multiple indexes per table
No forced physical ordering
But what does Postgres offers special here ??
ans - flexibility and concurrency
Other DBs optimize reads with clustered indexes.
Next, we will see what is more special in such indexing
3/3

[ASIF ISLAM @Asifoff7]

We talk about indexing.
Few understand how PostgreSQL actually does it.
It’s very different from databases that use clustered primary indexes.

Postgres doesn’t store data “inside” the index.
Instead, it separates:
1. Index (lookup)
2. Heap (actual data)
1/3

[ASIF ISLAM @Asifoff7]

Here’s how it works:
The table = heap (unordered rows on disk)
The index = map
When we query using an index:
Index → gives us a TID (tuple ID)
TID → points to the exact row in the heap
Wait ,think of it like:
Index = book’s table of contents
Heap = actual pages
2/3