Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is
slowed down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval)
Jean-Christophe ARNU (JX) <[EMAIL PROTECTED]> writes:
> When I use timestamps + interval in where clauses, query performance is
> slowed down by a factor of 20 or 30 For exemple :
> select timestamp,value
> from measure
> where timestamp(now() - '1 hour'::interval)
>
On 10 Apr 2002 at 10:55, Dan Langille wrote:
> If there is an index on that field, casting to a timestamp may help the
> optimization. Therefore I suggested that it be tried.
And using "explain" will show the plan for that command. I recommend
using that too.
--
Dan Langille
The FreeBSD Dia
On 10 Apr 2002 at 10:44, JX wrote:
> Le Wed, 10 Apr 2002 09:27:09 -0400
> "Dan Langille" <[EMAIL PROTECTED]> me disait que :
>
> > On 10 Apr 2002 at 9:13, JX wrote:
> >
> > > Le Wed, 10 Apr 2002 09:06:55 -0400
> > > "Dan Langille" <[EMAIL PROTECTED]> me disait que :
> > >
> > > > On 10 Apr 200
Le Wed, 10 Apr 2002 09:27:09 -0400
"Dan Langille" <[EMAIL PROTECTED]> me disait que :
> On 10 Apr 2002 at 9:13, JX wrote:
>
> > Le Wed, 10 Apr 2002 09:06:55 -0400
> > "Dan Langille" <[EMAIL PROTECTED]> me disait que :
> >
> > > On 10 Apr 2002 at 11:51, Gaetano Mendola wrote:
> > >
> > > > "Jea
On 10 Apr 2002 at 11:51, Gaetano Mendola wrote:
> "Jean-Christophe ARNU (JX)" <[EMAIL PROTECTED]> wrote:
> > Hello all.
> > I've a performance problem on specific requests :
> >
> > When I use timestamps + interval in where clauses, query performance is
> > slowed down by a factor of 20 or 3
"Jean-Christophe ARNU (JX)" <[EMAIL PROTECTED]> wrote:
> Hello all.
> I've a performance problem on specific requests :
>
> When I use timestamps + interval in where clauses, query performance is
> slowed down by a factor of 20 or 30 For exemple :
> select timestamp,value
> from measu
Hello all.
I've a performance problem on specific requests :
When I use timestamps + interval in where clauses, query performance is
slowed down by a factor of 20 or 30 For exemple :
select timestamp,value
from measure
where timestamp(now() - '1 hour'::interval
