Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow response to my query - Mailing list pgsql-novice

From Goke Aruna
Subject Re: Slow response to my query
Date
Msg-id CAE=DitpTVKmo7-KQDb+fQJzuG=Oz1ux1OP7cgFGhMGE4kCDO4A@mail.gmail.com
Whole thread Raw
In response to Re: Slow response to my query  (Bzzzz <lazyvirus@gmx.com>)
Responses Re: Slow response to my query
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Bzzzz
Date:
Subject: Re: Slow response to my query
Next
From: Bzzzz
Date:
Subject: Re: Slow response to my query