Re: Database creation performance drop going from pg 14 to pg 15+

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Database creation performance drop going from pg 14 to pg 15+
From: Thomas Munro <thomas.munro@xxxxxxxxx>
Date: Wed, 28 May 2025 23:29:04 +1200
Cc: Álvaro Herrera <alvherre@xxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <ad74d853-bd28-4e72-9ba5-1ca624c2d879@app.fastmail.com>
References: <202505271507.xvfbdztae74a@alvherre.pgsql> <ad74d853-bd28-4e72-9ba5-1ca624c2d879@app.fastmail.com>

On Wed, May 28, 2025 at 11:09 PM Mahdi Bahrami <pgsql@xxxxxxxxxxx> wrote:
> their tests now run in 15s instead of 1m30s

Wow.  If/when they get to v18, they might also try setting
file_copy_method=clone when using strategy=file_copy.

Follow-Ups:
- Re: Database creation performance drop going from pg 14 to pg 15+
  - From: Mahdi Bahrami

References:
- Re: Database creation performance drop going from pg 14 to pg 15+
  - From: Álvaro Herrera
- Re: Database creation performance drop going from pg 14 to pg 15+
  - From: Mahdi Bahrami

Prev by Date: Re: Database creation performance drop going from pg 14 to pg 15+
Next by Date: Re: Database creation performance drop going from pg 14 to pg 15+
Previous by thread: Re: Database creation performance drop going from pg 14 to pg 15+
Next by thread: Re: Database creation performance drop going from pg 14 to pg 15+
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux