Re: Select max(primary_key) taking a long time

Francisco Reyes <lists@stringsutils.com> writes:
> Tom Lane writes:
>> Francisco Reyes <lists@stringsutils.com> writes:
>>> I am trying to do
>>> select max(primary_key) from some_table;

>> Are there a whole lot of nulls in that column?

> Zero nulls. It is a primary key.

Huh.  The proposed plan should have run in basically zero time then.
You might try strace'ing the backend or attaching to it with gdb to
see what it's doing.

            regards, tom lane