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:
> 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?

			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