Re: Getting fancy errors when accessing information_schema on 10.5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Tom Lane <tgl@xxxxxxxxxxxxx>
Subject: Re: Getting fancy errors when accessing information_schema on 10.5
From: Axel Rau <Axel.Rau@xxxxxxxxx>
Date: Tue, 30 Oct 2018 16:51:00 +0100
Cc: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx, pgsql-hackers@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <30675.1540913357@sss.pgh.pa.us>
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> <29081.1540911887@sss.pgh.pa.us> <4BA9C14E-52CC-4578-A342-8705B2AFCCD3@Chaos1.DE> <30675.1540913357@sss.pgh.pa.us>

Am 30.10.2018 um 16:29 schrieb Tom Lane <tgl@xxxxxxxxxxxxx>:

Axel Rau <Axel.Rau@xxxxxxxxx> writes:
Am 30.10.2018 um 16:04 schrieb Tom Lane <tgl@xxxxxxxxxxxxx>:
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

I increased that value and the issue disappeared. (-:

Axel

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

References:
- Getting fancy errors when accessing information_schema on 10.5
  - From: Axel Rau
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Laurenz Albe
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Axel Rau
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Tom Lane
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Laurenz Albe
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Tom Lane
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Axel Rau
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Tom Lane
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Axel Rau
- Re: Getting fancy errors when accessing information_schema on 10.5
  - From: Tom Lane

Prev by Date: Re: Getting fancy errors when accessing information_schema on 10.5
Next by Date: ALTER PUBLICATION
Previous by thread: Re: Getting fancy errors when accessing information_schema on 10.5
Next by thread: creating table without columns
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]