News for hackers. Stuff that matters.

A comment on Postgres Indexes for Newbies. Parent comment

Re:Postgres Indexes for Newbies by timando on Wednesday January 19, 2022 @11:16PM (#30004534)
A BRIN index is basically a minimum and maximum value in the indexed column for each megabyte of table.
[ Parent | on HN ]
Re:Postgres Indexes for Newbies by jambalaya on Thursday January 20, 2022 @02:28PM (#30013528)
Had a question and curious if you know. Could an updated_at column work theoretically better than a created_at column if there are some deletes and updates? Would updated_at be ordered as they are on disk?
[ Parent | on HN ]