Re: Trimming the cost of ORDER BY in a simple query - Mailing list pgsql-sql

From Harald Fuchs
Subject Re: Trimming the cost of ORDER BY in a simple query
Date
Msg-id puu0lk60d7.fsf@srv.protecting.net
Whole thread Raw
In response to Trimming the cost of ORDER BY in a simple query  (<ogjunk-pgjedan@yahoo.com>)
List pgsql-sql
In article <1115104938.5853.25.camel@localhost.localdomain>,
Ragnar Hafstað <gnari@simnet.is> writes:

> 20 ms does not sound like a big problem.

> if 20 ms is really too much for you, and add_date IS a timestamp,
> you might think about adding a date column , maintained
> by triggers of by your application, and add an index on (user_id, x)

Maybe a functional index on "date_trunc('day', add_date)" would be helpful?



pgsql-sql by date:

Previous
From: Ragnar Hafstað
Date:
Subject: Re: Trimming the cost of ORDER BY in a simple query
Next
From: lucas@presserv.org
Date:
Subject: Re: Function or Field?