Query hangs sometimes
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Query hangs sometimes
From
: Metatrader EA <metatraderea@xxxxxxxxx>
Date
: Thu, 17 Nov 2016 11:43:19 +0100
Hi,
I run this query select count(*) from analyse_forecast where daterange_analyse <@ daterange( current_date - 150, current_date, '[]') ;
Sometimes will query be quick and sometimes is same query SUPER SLOWWWW
Something I can do ? Something I can check for ?
//Bill
Follow-Ups
:
Re: Query hangs sometimes
From:
Guillaume Cottenceau
Prev by Date:
Run one query and execution time is very different
Next by Date:
Re: Query hangs sometimes
Previous by thread:
Run one query and execution time is very different
Next by thread:
Re: Query hangs sometimes
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
