Postgres Indexes for Newbies • Hacker News Board

Re: Postgres Indexes for Newbies

#41

Post by hans_castorp » Fri, Jan 21, 2022, 6:21 AM UTC

tomnipotent wrote: post #39

hans_castorp wrote: post #35

Earlier quoted context omitted.

> SQL Server and Oracle both default to heaps I don't think that's true for SQL Server. If you define a primary key in SQL Server, this is automatically a clustered index.

Any table in SQL Server without a clustered index will be stored as a heap. https://docs.microsoft.com/en-us/sql/relational-databases/in...

Yes, but the _default_ (and that's what I was referring to) is a clustered index.

Re: Postgres Indexes for Newbies

#42

Post by tomnipotent » Sat, Jan 22, 2022, 5:36 AM UTC

hans_castorp wrote: post #41

tomnipotent wrote: post #39

Earlier quoted context omitted.

Any table in SQL Server without a clustered index will be stored as a heap. https://docs.microsoft.com/en-us/sql/relational-databases/in...

Yes, but the _default_ (and that's what I was referring to) is a clustered index.

Then the definition depends on whether you consider adding a primary key as default or not. I would not consider it default, though it is customary.

Re: Postgres Indexes for Newbies

#43

Post by Tostino » Tue, Jan 25, 2022, 6:47 PM UTC

tomnipotent wrote: post #24

eatonphil wrote: post #14

Use the index, Luke is always a great resource. [0] https://use-the-index-luke.com/

Another amazing resource are the CMU Database Systems videos with Prof. Andy Pavlo. Videos from 2021 with a different professor (Andrew Crotty) have also been uploaded, but Pavlo is just so engaging. https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_... (Pavlo, 2019) https://www.youtube.com/playlist?list=PLSE8ODhjZXjZaHA6QcxDf... (Crotty, 2021)

He really is engaging. I love the guest talks too.