Postgres Pro
Downloads
Home   >   mailing lists

Re: select max(field) from table much faster with a group by clause? - Mailing list pgsql-performance

From Tom Lane
Subject Re: select max(field) from table much faster with a group by clause?
Date
Msg-id 5504.1193929617@sss.pgh.pa.us
Whole thread Raw
In response to Re: select max(field) from table much faster with a group by clause?  (Palle Girgensohn <girgen@pingpong.net>)
Responses Re: select max(field) from table much faster with a group by clause?  (Palle Girgensohn <girgen@pingpong.net>)
Re: select max(field) from table much faster with a group by clause?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
Palle Girgensohn <girgen@pingpong.net> 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

pgsql-performance by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: select max(field) from table much faster with a group by clause?
Next
From: Palle Girgensohn
Date:
Subject: Re: select max(field) from table much faster with a group by clause?