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

["Scott Marlowe" <scott.marlowe@xxxxxxxxx>]

On 11/1/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> Palle Girgensohn <girgen@xxxxxxxxxxxx> writes:
> > Unfortunately, altering statistics doesn't help. I see no difference when
> > altering the value from 10 (default) to 100, 1000 or 100000. :-(
>
> Um, you did re-ANALYZE the table after changing the setting?

And he changed it with

ALTER TABLE name ALTER [ COLUMN ] column SET STORAGE { PLAIN |
EXTERNAL | EXTENDED | MAIN }

right?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend