Re: PostgreSQL 11 higher Planning time on Partitioned table

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Ravi Garg <ravi(dot)garg(at)yahoo(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL 11 higher Planning time on Partitioned table
Date: 2020-02-23 10:46:09
Message-ID: 20200223104609.GA27688@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ravi Garg 2020-02-23 10:57:29 Re: PostgreSQL 11 higher Planning time on Partitioned table
Previous Message Peter J. Holzer 2020-02-23 10:19:28 Re: DB running out of memory issues after upgrade