Re: [HACKERS] PG 10 release notes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] PG 10 release notes
Date
Msg-id 20170425173036.GV7513@momjian.us
Whole thread Raw
In response to Re: [HACKERS] PG 10 release notes  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] PG 10 release notes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Apr 25, 2017 at 10:00:52AM -0700, Andres Freund wrote:
> at this point, you can see, we've squarely left O(N) country, and
> entered the vast O(N^2) waste.
> 
> 10      10                9ms
> 10      100              22ms
> 10      1000            162ms
> 10      10000          1497ms
> 10      100000        17260ms
> 10      200000        39275ms
> 
> Here we roughly stay in O(N).
> 
> (there's some other suboptimal behaviour in smgrclose(); but that's for
> another day)

OK, I got it now. :-)  Here is the new item:
       Improve table creation speed in sessions that reference many       relations (Aleksander Alekseev)

--  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: [HACKERS] PG 10 release notes
Next
From: Claudio Freire
Date:
Subject: Re: [HACKERS] PG 10 release notes