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

Palle Girgensohn <girgen@pingpong.net> writes:
> --On torsdag, november 01, 2007 11.06.57 -0400 Tom Lane <tgl@sss.pgh.pa.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