Am I missing something or is uniqueness a game breaker here? Since B is not a primary key we have no guarantee on the uniqueness and therefore we might have millions of records between 50 and 50000
Good stuff my guy. It’d be great to have some visuals with the type of discussions just to bring the point home. Anyway, I appreciate these videos a lot. Thanks Hussein! 😁
I am continuing to Add to my portfolio. As warren Buffet said "be brave when everyone else is fearful ". The stock market ALWAYS recover, so hold for long term and have the stomach for the ride 👍.
IF, A was not a primary key but had a clustered index , then what ? Once you find page for value 50 by doing a primary index scan for the value you got from A's index, every consecutive items in the page and the consecutive pages will have the required data (since it's clustered). BUT, is the database smart enough to know that it doesn't need to scan the primary index for each of the values which it finds in A's index ?
Am I missing something or is uniqueness a game breaker here? Since B is not a primary key we have no guarantee on the uniqueness and therefore we might have millions of records between 50 and 50000
That is a great point for sure 👍
Oh good point! I didn't even think of that. I was only thinking in terms of the index.
Good stuff my guy. It’d be great to have some visuals with the type of discussions just to bring the point home. Anyway, I appreciate these videos a lot. Thanks Hussein! 😁
It's 'analyze table' in PostgreSQL, mostly paired with vacuum as far as I use it :)
I am continuing to Add to my portfolio. As warren Buffet said "be brave when everyone else is fearful ". The stock market ALWAYS recover, so hold for long term and have the stomach for the ride 👍.
Mrs Sarah really is doing a lot of people a genuine favor with her daily signal! I've earned alot also
saw recommendation but I did not bother chating her up
Wow i'm glad i did. I withdrew my first profit two days ago now I have another ongoing trade with her
The fruitfulness of your trading lies on the account manager or the expert
I have been seeing so many recommendations about Mrs Sarah on different platforms trending I think she must be good for people to talk about her
IF, A was not a primary key but had a clustered index , then what ? Once you find page for value 50 by doing a primary index scan for the value you got from A's index, every consecutive items in the page and the consecutive pages will have the required data (since it's clustered). BUT, is the database smart enough to know that it doesn't need to scan the primary index for each of the values which it finds in A's index ?
@hnasr , if possible can you please do some live coding for building backend systems?
pretty sure in postgres ANALYZE updates table stats
We can explore internals on primary index built from multiple columns, maybe there is something interesting there
I think that it's built with just concatenated values of columns
@@weathercontrol0 how would you concatenate different data types, like date and uint and enum?
@@MartinsTalbergs after all, it's all just bytes, I don't think there's a problem concatenating different data types
@@weathercontrol0 there should be a problem, because an index has to be built... Naively, sure - they could do basic BTREE of zeroes and ones
This was so much fun!
nice video, can you make one with the books from bookshelve explaining them?
Nice haircut. You look good.
There's a typo in your chapter titles btw
Thanks fixed!
First to comment
Are you uzbek?
Early
Hello, Just watched your video course on HA Proxy --> it's really good quality content. Thanks a lot for doing it 🙂