Home > mailing lists

Re: Too slow querying a table of 15 million records - Mailing list pgsql-performance

From	Tom Lane
Subject	Re: Too slow querying a table of 15 million records
Date	June 28, 2005 15:15:51
Msg-id	22415.1119982482@sss.pgh.pa.us Whole thread Raw
In response to	Re: Too slow querying a table of 15 million records (PFC <lists@boutiquenumerique.com>)
List	pgsql-performance

Tree view

PFC <lists@boutiquenumerique.com> writes:
>     1. Use CURRENT_TIMESTAMP (which is considered a constant by the planner)
> instead of now()

Oh?

            regards, tom lane

pgsql-performance by date:

From: John A Meinel
Date: 28 June 2005, 14:43:59
Subject: Re: tricky query

From: Sam Mason
Date: 28 June 2005, 15:49:10
Subject: Re: tricky query

Re: Too slow querying a table of 15 million records - Mailing list pgsql-performance

Previous

Next