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 6024.1193931282@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>)
List pgsql-performance
Tree view 
Palle Girgensohn <girgen@pingpong.net> writes:
> --On torsdag, november 01, 2007 11.06.57 -0400 Tom Lane <tgl@sss.pgh.pa.us>
> 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

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: select max(field) from table much faster with a group by clause?
Next
From: Gregory Stark
Date:
Subject: Re: select max(field) from table much faster with a group by clause?