On 2011-06-16 15:55, Svetlin Manavski wrote:
> Hi everybody,
> I am running PostgreSQL 9.0 which performs well in most of the cases. I
> would skip all the parameters if these are not necessary.
> I need to frequently (every min) get the max value of the primary key column
> on some tables, like this case which works perfectly well:
> explain analyze select max(id) from appqosdata.tcpsessions;
Typically this is due to "batch load" and failing to run "analyze"
manually afterwards.. is this the case?
In response to
pgsql-performance by date
|Next:||From: Magnus Hagander||Date: 2011-06-16 17:25:56|
|Subject: Re: seq scan in the case of max() on the primary key column|
|Previous:||From: Haestan||Date: 2011-06-16 15:09:54|
|Subject: Performance advice for a new low(er)-power server|