Home > mailing lists

Re: Querying 19million records very slowly - Mailing list pgsql-performance

From	PFC
Subject	Re: Querying 19million records very slowly
Date	June 21, 2005 21:33:41
Msg-id	op.ssqot4d4th1vuj@localhost Whole thread Raw
In response to	Re: Querying 19million records very slowly (Paul Ramsey <pramsey@refractions.net>)
Responses	Re: Querying 19million records very slowly
List	pgsql-performance

use CURRENT_TIME which is a constant instead of now() which is not
considered constant... (I think)

From: Tom Lane
Date: 21 June 2005, 21:20:31
Subject: Re: Limit clause not using index

From: William Yu
Date: 21 June 2005, 21:54:13
Subject: Re: Trying to figure out pgbench