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
