Postgres Pro
Downloads
Home   >   mailing lists

Re: Select max(primary_key) taking a long time - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Select max(primary_key) taking a long time
Date
Msg-id cone.1274464083.213012.30938.1000@shelca
Whole thread Raw
In response to Select max(primary_key) taking a long time  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: Select max(primary_key) taking a long time
Re: Select max(primary_key) taking a long time
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: getting all constraint violations
Next
From: Tom Lane
Date:
Subject: Re: Select max(primary_key) taking a long time