Question d’entretien chez DataArt

How do indexes in PostgreSQL actually work on a database level?