Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioned tables referenced by FKs - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: partitioned tables referenced by FKs
Date
Msg-id 20190321221824.GA29134@alvherre.pgsql
Whole thread Raw
In response to Re: partitioned tables referenced by FKs  (Jesper Pedersen <jesper.pedersen@redhat.com>)
Responses Re: partitioned tables referenced by FKs
List pgsql-hackers
Tree view 
Hi Jesper

On 2019-Mar-21, Jesper Pedersen wrote:

> running
> 
> pgbench -M prepared -f select.sql ....
> 
> I'm seeing 82.64% spent in GetCachedPlan(). plan_cache_mode is auto.

Hmm, I can't reproduce this at all ...  I don't even see GetCachedPlan
in the profile.  Do you maybe have some additional patch in your tree?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: partitioned tables referenced by FKs
Next
From: Lucas Viecelli
Date:
Subject: warning to publication created and wal_level is not set to logical