Open JasonYao opened 1 year ago
Some info at https://blog.quest.com/a-guide-to-using-postgres-indexes/ and the main docs at https://www.postgresql.org/docs/current/sql-createindex.html
Types: B-tree, hash, GiST, SP-GiST, GIN, and BRIN
If we know that we're looking for an exact match in a composite array (searching full text, or using arrays), use GIN etc. etc. and make a flowchart to help visualize this
Some info at https://blog.quest.com/a-guide-to-using-postgres-indexes/ and the main docs at https://www.postgresql.org/docs/current/sql-createindex.html
Types: B-tree, hash, GiST, SP-GiST, GIN, and BRIN
If we know that we're looking for an exact match in a composite array (searching full text, or using arrays), use GIN etc. etc. and make a flowchart to help visualize this