Horton

Re: Slow response to my query

Bzzzz <lazyvirus@gmx.com>

View thread View on postgr.es
From: Bzzzz <lazyvirus@gmx.com>
To: Goke Aruna <goksie@gmail.com>
Cc: Steven Pousty <steve.pousty@gmail.com>, pgsql-novice@lists.postgresql.org, Babatunde Adeyemi <barbietunnie@gmail.com>
Date: 2019-11-29T14:21:25Z
Lists: pgsql-novice 
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