Dear all,
Changing the function signature to IMMUTABLE worked like a dream. No issue
now. Sorry for my confusion on VOLATILE being created as the default. Thanks
to everyone for your help!
Kind regards,
Rick Vincent
From: David G. Johnston
Sent: Friday, April 17, 2020 4:55 PM
To: Rick
Hi David,
Oh, okay…I missed that implied part. Will try it and post back.
Thanks,
Rick
From: David G. Johnston
Sent: Friday, April 17, 2020 4:55 PM
To: Rick Vincent
Cc: Tom Lane ; Justin Pryzby ;
pgsql-performa...@postgresql.org; Manoj Kumar ; Herve
Aubert
Subject: Postgres not using
Hi,
I was wondering if anyone can explain the below problem. Should a bug be
logged for this?
Kind regards,
Rick
_
From: Rick Vincent
Sent: Tuesday, April 7, 2020 11:08 AM
To: 'Tom Lane' ; Justin Pryzby
Cc: pgsql-performa...@postgresql.
assubclass reloptions pg_table_size
FBNK_CURRENCY 6 93 0 r 2 false NULL81920
Version is:
PostgreSQL 11.7 (Debian 11.7-2.pgdg90+1) on x86_64-pc-linux-gnu, compiled by
gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
It is a postgres docker image.
Than
ly slow.
Thanks,
Rick
-Original Message-
From: Justin Pryzby
Sent: Tuesday, April 7, 2020 6:59 AM
To: Rick Vincent
Cc: pgsql-performa...@postgresql.org; Manoj Kumar ;
Herve Aubert
Subject: Re: Postgres not using index on views
On Mon, Apr 06, 2020 at 02:19:59PM +, Rick Vincent
Hi,
I am seeing a performance problem with postgresql v 11.7 on views, and I am
wondering if anyone can tell me why or has any suggestion.
A table is created as:
CREATE TABLE "FBNK_CUSTOMER" (RECID VARCHAR(255) NOT NULL PRIMARY KEY,
XMLRECORD VARCHAR)
And contains only 180 rows.
Doing an exp
