Re: [Sender Address Forgery]Re: Postgres 11 release notes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [Sender Address Forgery]Re: Postgres 11 release notes
Date
Msg-id 20180523013652.GG12538@momjian.us
Whole thread Raw
In response to Re: [Sender Address Forgery]Re: Postgres 11 release notes  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: Postgres 11 release notes  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
On Wed, May 23, 2018 at 10:28:41AM +0900, Amit Langote wrote:
> > Uh, we already have this in the release notes:
> > 
> >         Allow faster partition elimination during query processing (Amit
> >         Langote, David Rowley, Dilip Kumar)
> > 
> >         This speeds access to partitioned tables with many partitions.
> > 
> > Do you want me to add the git commit hash to this release note entry?
> 
> I suppose you meant the above as an entry for performance improvement of
> partition "pruning".  The commit I quoted is concerned with making "tuple
> routing" a bit faster, but as David said that's not making it as fast as
> it could really be.  So, we should hold off from touting it as an
> improvement at this point and I have to agree.  Sorry for the noise.

OK, no problem.  So _finding_ the rows is faster, but adding rows to
partitioned tables with many partitions is still slow, got it.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgres 11 release notes
Next
From: Thomas Munro
Date:
Subject: Re: Postgres 11 release notes