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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Palle Girgensohn <girgen@xxxxxxxxxxxx> writes:
> --On torsdag, november 01, 2007 11.06.57 -0400 Tom Lane <tgl@xxxxxxxxxxxxx> 
> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux