Re: Query hangs sometimes

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: Metatrader EA <metatraderea(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query hangs sometimes
Date: 2016-11-17 11:02:34
Message-ID: m34m36nzcl.fsf@lmeuh2.fritz.box
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Metatrader EA 2016-11-17 11:55:11 Re: Query hangs sometimes
Previous Message Metatrader EA 2016-11-17 10:43:19 Query hangs sometimes