Re: Getting fancy errors when accessing information_schema on 10.5

From: Axel Rau <Axel(dot)Rau(at)chaos1(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
Date: 2018-10-30 15:12:32
Message-ID: 4BA9C14E-52CC-4578-A342-8705B2AFCCD3@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin pgsql-hackers

> Am 30.10.2018 um 16:04 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE <mailto:Axel(dot)Rau(at)Chaos1(dot)DE>> writes:
>> Am 30.10.2018 um 14:45 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)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?

Yes:

cpu_index_tuple_cost = 0.01
cpu_operator_cost = 0

effective_cache_size = 4GB

Axel
---
PGP-Key:29E99DD6 ☀ computing @ chaos claudius

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2018-10-30 15:29:17 Re: Getting fancy errors when accessing information_schema on 10.5
Previous Message Tom Lane 2018-10-30 15:04:47 Re: Getting fancy errors when accessing information_schema on 10.5

Browse pgsql-hackers by date

  From Date Subject
Next Message Sergei Kornilov 2018-10-30 15:14:00 Re: [HACKERS] generated columns
Previous Message Tom Lane 2018-10-30 15:04:47 Re: Getting fancy errors when accessing information_schema on 10.5