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]

 





--On torsdag, november 01, 2007 11.06.57 -0400 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?

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


---------------------------(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