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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: select max(field) from table much faster with a group by clause?
Date: 2007-11-01 15:06:57
Message-ID: 5504.1193929617@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Palle Girgensohn <girgen(at)pingpong(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Palle Girgensohn 2007-11-01 15:25:08 Re: select max(field) from table much faster with a group by clause?
Previous Message Palle Girgensohn 2007-11-01 14:36:29 Re: select max(field) from table much faster with a group by clause?