Re: select max(field) from table much faster with a group by clause?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: select max(field) from table much faster with a group by clause?
Date: 2007-11-01 15:34:42
Message-ID: 6024.1193931282@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
> --On torsdag, november 01, 2007 11.06.57 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> wrote:
>> Um, you did re-ANALYZE the table after changing the setting?

> alter table login alter userid SET statistics 1000;
> vacuum analyze login;

Hm, that's the approved procedure all right. But the plans didn't
change at all? Not even the estimated number of rows?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-11-01 15:47:32 Re: select max(field) from table much faster with a group by clause?
Previous Message Scott Marlowe 2007-11-01 15:28:53 Re: select max(field) from table much faster with a group by clause?