From: Tom Lane <tgl@sss.pgh.pa.us>
To: Axel Rau <Axel.Rau@Chaos1.DE>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Date: Tue, 30 Oct 2018 11:04:47 -0400
Message-ID: <29081.1540911887@sss.pgh.pa.us> (raw)
In-Reply-To: <EC747F72-288E-4F97-A56E-BD54D9507B4D@Chaos1.DE>
References: <D8BA4170-2E96-42BE-8CEC-E9FCF75B0DD4@Chaos1.DE>
<4880e067723cefc1dc2e08a117f96de26ae0f797.camel@cybertec.at>
<44D4C7B1-0DCF-4166-9DB8-B5D75EB2985E@Chaos1.DE>
<20191.1540901834@sss.pgh.pa.us>
<31055688b81895792fa7d8c61e07dca7add3dbb9.camel@cybertec.at>
<15908.1540907134@sss.pgh.pa.us>
<EC747F72-288E-4F97-A56E-BD54D9507B4D@Chaos1.DE>
Axel Rau <Axel.Rau@Chaos1.DE> writes:
> Am 30.10.2018 um 14:45 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>> Axel, would you try two more things on that DB?
> nextcloud=> explain select ((pg_has_role(relowner, 'USAGE'::text) OR has_sequence_privilege(oid, 'SELECT, UPDATE, USAGE'::text))) from pg_class;
> QUERY PLAN
> -----------------------------------------------------------
> Seq Scan on pg_class (cost=0.00..28.56 rows=656 width=1)
> (1 row)
> nextcloud=> explain select (relkind = 'S'::"char") from pg_class;
> QUERY PLAN
> -----------------------------------------------------------
> Seq Scan on pg_class (cost=0.00..28.56 rows=656 width=1)
> (1 row)
That is ... odd. Is it possible that you have cpu_operator_cost set
to zero, or some very tiny number?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Axel.Rau@Chaos1.DE, laurenz.albe@cybertec.at
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
In-Reply-To: <29081.1540911887@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox