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

Re: Querying 19million records very slowly

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Paul Ramsey" <pramsey(at)refractions(dot)net>,"Kjell Tore Fossbakk" <kjelltore(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Querying 19million records very slowly
Date: 2005-06-21 21:33:30
Message-ID: op.ssqot4d4th1vuj@localhost (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
use CURRENT_TIME which is a constant instead of now() which is not  
considered constant... (I think)

In response to


pgsql-performance by date

Next:From: William YuDate: 2005-06-21 21:53:52
Subject: Re: Trying to figure out pgbench
Previous:From: Tom LaneDate: 2005-06-21 21:20:07
Subject: Re: Limit clause not using index

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