PostgreSQL provides several index types. Each index type uses a different algorithm that is best suited to different types of queries. By default, the CREATE INDEX command will create a index, which fits the most common situations. The default access method is
