Re: Query hangs sometimes - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: Query hangs sometimes
Date
Msg-id m34m36nzcl.fsf@lmeuh2.fritz.box
Whole thread Raw
In response to Query hangs sometimes  (Metatrader EA <metatraderea@gmail.com>)
Responses Re: Query hangs sometimes  (Metatrader EA <metatraderea@gmail.com>)
List pgsql-performance
Locks? (VACUUM FULL, etc) Autovacuum?

> 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
>

--
Guillaume Cottenceau


pgsql-performance by date:

Previous
From: Metatrader EA
Date:
Subject: Query hangs sometimes
Next
From: Metatrader EA
Date:
Subject: Re: Query hangs sometimes