Skip site navigation (1) Skip section navigation (2)

Re: is it possible to make this faster?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: is it possible to make this faster?
Date: 2006-05-25 20:36:30
Message-ID: 200605251336.30985@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-performance
On May 25, 2006 01:31 pm, "Merlin Moncure" <mmoncure(at)gmail(dot)com> wrote:
> > SELECT DISTINCT ON (a, b) a, b, c FROM t ORDER BY a DESC, b DESC, c
> > DESC;
>
> that is actually slower than group by in my case...am i missing
> something? (both essentially resolved to seq_scan)

Try it with an index on a,b,c.

-- 
Alan

In response to

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2006-05-25 20:47:46
Subject: Re: is it possible to make this faster?
Previous:From: Merlin MoncureDate: 2006-05-25 20:31:40
Subject: Re: is it possible to make this faster?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group