Indexes in PostgreSQL

A record is a particular structure that composes a reference to your information that makes it less demanding to gaze upward. In Postgres it is a duplicate of the thing you wish to file joined with a reference to the genuine information area. While getting to information, Postgres will either utilize some type of a file on the off chance that it exists or a successive output. A successive sweep is the point at which it looks over the greater part of the information before giving back the outcomes. HDD (Hard Disk Drive) has a wide crevice between the execution of consecutive I/O and that of irregular I/O inferable from its mechanical parts. Because of this reality, DBMS more often than not lean toward a full table sweep to a record filter aside from when selectivity is sufficient low to exploit list check. Here, an advancement of the list sweep is actualized, called streak mindful list check by joining two ideas in PostgreSQL. An idea is a sorted list filter that sweeps tuples all together of record ids.