Re: PostgreSQL 11 higher Planning time on Partitioned table - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: PostgreSQL 11 higher Planning time on Partitioned table
Date
Msg-id 20200223104609.GA27688@telsasoft.com
Whole thread Raw
In response to Re: PostgreSQL 11 higher Planning time on Partitioned table  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
On Sun, Feb 23, 2020 at 04:12:09AM -0600, Justin Pryzby wrote:
> How large are the partitions and how many indexes each, and how large are they?
> Each partition will be stat()ed ... for every query.

I should have said that's every 1GB "segment" is stat()ed for every query.

> This was resolved in pg12:
> https://commitfest.postgresql.org/21/1778/

+ https://www.postgresql.org/about/featurematrix/detail/320/

-- 
Justin



pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: PostgreSQL 11 higher Planning time on Partitioned table
Next
From: Ravi Garg
Date:
Subject: Re: PostgreSQL 11 higher Planning time on Partitioned table