Postgres Pro
Downloads
Home   >   mailing lists

Query hangs sometimes - Mailing list pgsql-performance

From Metatrader EA
Subject Query hangs sometimes
Date
Msg-id CAJNXAk1MDZZ6UYApOPuZ3kYm4wT6=1fyK997onALaca6NHFdNA@mail.gmail.com
Whole thread Raw
Responses Re: Query hangs sometimes  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Metatrader EA
Date:
Subject: Run one query and execution time is very different
Next
From: Guillaume Cottenceau
Date:
Subject: Re: Query hangs sometimes