Horton

Re: Slow response to my query

Goke Aruna <goksie@gmail.com>

View thread View on postgr.es
From: Goke Aruna <goksie@gmail.com>
To: Bzzzz <lazyvirus@gmx.com>
Cc: Steven Pousty <steve.pousty@gmail.com>, pgsql-novice@lists.postgresql.org, Babatunde Adeyemi <barbietunnie@gmail.com>
Date: 2019-11-29T14:38:53Z
Lists: pgsql-novice 
Thanks Jean-Yves / Steven,
am using V12.

On Fri, Nov 29, 2019 at 3:21 PM Bzzzz <lazyvirus@gmx.com> wrote:

> On Fri, 29 Nov 2019 12:09:04 +0100
> Goke Aruna <goksie@gmail.com> wrote:
>
> Oops, I forgot,
>
> as you're not using V.12, it might not be a bad idea to create  new
> columns and trigger(s) to pre-calculate all of the EXTRACT/2 you need.
>
> Jean-Yves
>