title: Does Postgres use index on BIGINT columns?
body: <p>I'm trying to understand whether Postgres uses indexes on BIGINT columns. The ddl to create the table and the corresponding index works. But when searching via Google, there were some articles (quite old) that said that there are some issues with BIGINT column indexes (they're not used). Unfortunately, I don't have enough sample data available to verify this using EXPLAIN.</p>
  
  <pre><code>create table ab.sample
  (
    id integer primary key generated always as identity,
    some_id bigint
  );
  
  create unique index sample_some_id_idx on ab.sample(some_id);
  </code></pre>