On Thu, Nov 18, 2021 at 04:39:42PM +1300, Thomas Munro wrote:
> On Thu, Nov 18, 2021 at 1:18 PM Robert Creager
> wrote:
> > So, how do I go about capturing more information for the big brains (you
> > guys) to help figure this out? I have all our resources at mine (and hence
> > your) disposal
On Thu, Nov 18, 2021 at 1:18 PM Robert Creager wrote:
> So, how do I go about capturing more information for the big brains (you
> guys) to help figure this out? I have all our resources at mine (and hence
> your) disposal.
As a workaround, does it help if you issue DISCARD PLANS before your
C
> On Nov 17, 2021, at 4:18 PM, Justin Pryzby wrote:
>
> This message originated outside your organization.
>
> On Wed, Nov 17, 2021 at 09:54:14PM +, Robert Creager wrote:
> > We are able to move up to Postgres 13.5, in our ports tree, if that would
> > help. We used pg_upgrade to get from
On Wed, Nov 17, 2021 at 09:54:14PM +, Robert Creager wrote:
> We are able to move up to Postgres 13.5, in our ports tree, if that would
> help. We used pg_upgrade to get from 9.6 to 13.3, so that should work fine
> going instead to 13.5. We’re almost branching/releasing our code, so it’s
>
On Thu, Nov 18, 2021 at 8:28 AM Tom Lane wrote:
> Justin Pryzby writes:
> > It shows that the process is running FK triggers.
>
> Indeed, and doing a seqscan therein. Normally I'd suppose that
> this reflects a lack of an index, but RI_FKey_check should always
> be doing something that matches t
On Nov 17, 2021, at 12:00 PM, Justin Pryzby
mailto:pry...@telsasoft.com>> wrote:
This message originated outside your organization.
On Wed, Nov 17, 2021 at 05:51:05PM +, Robert Creager wrote:
postgres`HeapTupleSatisfiesVisibility+0x42
postgres`heapgetpage+0x237
Justin Pryzby writes:
> It shows that the process is running FK triggers.
Indeed, and doing a seqscan therein. Normally I'd suppose that
this reflects a lack of an index, but RI_FKey_check should always
be doing something that matches the referenced table's unique
constraint, so why isn't it usi
On Wed, Nov 17, 2021 at 05:51:05PM +, Robert Creager wrote:
> postgres`HeapTupleSatisfiesVisibility+0x42
> postgres`heapgetpage+0x237
> postgres`heapgettup_pagemode+0x5ad
> postgres`heap_getnextslot+0x52
> postgres`SeqNext+0x
On Nov 17, 2021, at 10:51 AM, Robert Creager
mailto:robe...@spectralogic.com>> wrote:
On Nov 15, 2021, at 10:50 PM, Thomas Munro
mailto:thomas.mu...@gmail.com>> wrote:
This message originated outside your organization.
On Tue, Nov 16, 2021 at 5:43 PM Robert Creager
mailto:robe...@spectral
