On 15-11-2005 15:18, Steve Wampler wrote:
Magnus Hagander wrote: (This is after putting an index on the (id,name,value) tuple.) That outer seq scan is still annoying, but maybe this will be fast enough. I've passed this on, along with the (strong) recommendation that they upgrade PG.
Have you tried with an index on (name,value) and of course one on id ? Best regards, Arjen ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
