Vincent
Cc: Tom Lane ; Justin Pryzby ;
pgsql-performa...@postgresql.org; Manoj Kumar ; Herve
Aubert
Subject: Postgres not using index on views
On Friday, April 17, 2020, Rick Vincent
mailto:rvinc...@temenos.com>> wrote:
Hi,
I was wondering if anyone can explain the below problem. Should
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
day, April 7, 2020 11:08 AM
> *To:* 'Tom Lane' ; Justin Pryzby
> *Cc:* pgsql-performa...@postgresql.org; Manoj Kumar <
> manojku...@temenos.com>; Herve Aubert
> *Subject:* RE: Postgres not using index on views
>
>
> Hi Tom,
>
> The function is d
org; Manoj Kumar ;
Herve Aubert
Subject: RE: Postgres not using index on views
Hi Tom,
The function is defined as below, so no use of VOLATILE. Let me know if you
need any other information. I am hoping the below will further clarify the
issue.
CREATE OR REPLACE FUNCTION extractValueJS (sVar
> RV>> It simply is the way the application stores the data. For Oracle
> we are storing in XML and JSON format, for postgres, due do
> limitations of XML api, we are storing in VARCHAR.
Why not use JSON in Postgres then?
Postgres' JSON functions are at least as powerful as Oracle's (if not bette
Rick Vincent schrieb am 07.04.2020 um 11:08:
> The function is defined as below, so no use of VOLATILE.
If you don't specify anything, the default is VOLATILE.
So your function *is* volatile.
> CREATE OR REPLACE FUNCTION extractValueJS (sVar text, nfm INTEGER, nvm
> INTEGER)
> RETURNS VARCHAR
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
On Mon, 2020-04-06 at 14:19 +, Rick Vincent wrote:
> 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.
Your account is somewhat confused - too many questions rolled into one
rant, I would say.
There are
Justin Pryzby writes:
> On Mon, Apr 06, 2020 at 02:19:59PM +, Rick Vincent wrote:
>> The following query takes an extremely long time for only 180 rows, and what
>> this means is that we would have to index anything appearing in the where
>> clause for every table in order to use views becau
On Mon, Apr 06, 2020 at 02:19:59PM +, Rick Vincent wrote:
> 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 PRIMAR
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
12 matches
Mail list logo
