Database Clustered vs Non-Clustered Index

[@QianyuHuang-d3u]

this is an amazing video ever! watched so many videos and yours is the first one which explains the logic well!

[@dyna2203]

You have covered almost everything with good animations.

[@piotrbeda6887]

Best explanation of indexes on YT I've ever seen

[@th30z-code]

Thank you, I really appreciate!

[@theboringdev]

I wish your video will reach more viewers.

[@dmitriyps22]

So what do we do we clustered indices in PostgreSQL? Is a table heap-organized by default there?

[@th30z-code]

PostgreSQL uses heap-based tables by default, so data is stored unordered. You can use the CLUSTER command to physically reorder the table based on the index. But clustering in postgres (via the CLUSTER command) is a one-time operation. there will be no attempt to store new or updated rows according to the clustered index, you have to perform another CLUSTER operation to sort the table again.