"Marko Niinimaki" <manzikki(at)gmail(dot)com> writes:
> I'm having a surprising performance problem with the following simple
> 'highscore report'
> select studentid, (select max(score) from
> studentprofile prof where prof.studentid = students.studentid) from students;
> I have indexes on students(studentid) and studentprofile(studentid).
The optimal index for this would be on studentprofile(studentid,score).
A quick test says that PG 8.1 knows what to do with such an index ---
what does EXPLAIN show for this query?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Rafa Comino||Date: 2007-02-20 10:41:54|
|Subject: Having performance problems with TSearch2|
|Previous:||From: ismo.tuononen||Date: 2007-02-20 07:21:45|
|Subject: Re: slow subselects|