[EMAIL PROTECTED] writes: > On 24 Sep, Greg Stark wrote: > > [EMAIL PROTECTED] writes: > > > >> On 22 Sep, Greg Stark wrote: > >> > Are those response times in the right unit? 7-10s? > > No problem: http://developer.osdl.org/markw/misc/plana.out
Ok, I guess I misunderstood you. These queries are taking 0.5ms - 300ms except for the last aggregate query which takes just over 1s. -- greg ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match