Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 01 Nov 2007 11:34:42 -0400
Palle Girgensohn <girgen(at)pingpong(dot)net> writes: > --On torsdag, november 01, 2007 11.06.57 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
- Follow-Ups:
- Re: select max(field) from table much faster with a group by clause?
- From: Palle Girgensohn
- Re: select max(field) from table much faster with a group by clause?
- References:
- select max(field) from table much faster with a group by clause?
- From: Palle Girgensohn
- Re: select max(field) from table much faster with a group by clause?
- From: Tom Lane
- Re: select max(field) from table much faster with a group by clause?
- From: Palle Girgensohn
- Re: select max(field) from table much faster with a group by clause?
- From: Tom Lane
- Re: select max(field) from table much faster with a group by clause?
- From: Palle Girgensohn
- select max(field) from table much faster with a group by clause?
- Prev by Date: Re: select max(field) from table much faster with a group by clause?
- Next by Date: Re: select max(field) from table much faster with a group by clause?
- Previous by thread: Re: select max(field) from table much faster with a group by clause?
- Next by thread: Re: select max(field) from table much faster with a group by clause?
- Indexes: