'Does the value of a indexed field affects performance?

I have the following table:

create type size_type as enum('tiny', 'small', 'tall');

CREATE TABLE IF NOT EXISTS people ( 
    size size_type NOT NULL 
);

Imagine it has tons of data. If I index the size field, the length of the strings on the enum will affect the performance of the database when executing queries? For example, ('ti','s',ta') will be more performatic than ('tiny', 'small', 'tall') or it doesn't matter?

postgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions