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: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: "Palle Girgensohn" <girgen(at)pingpong(dot)net>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: select max(field) from table much faster with a group by clause?
- Date: Thu, 1 Nov 2007 10:28:53 -0500
On 11/1/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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?
And he changed it with
ALTER TABLE name ALTER [ COLUMN ] column SET STORAGE { PLAIN |
EXTERNAL | EXTENDED | MAIN }
right?
- 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
- 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: