| From: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
|---|---|
| To: | Scott Mead <scott(at)meads(dot)us> |
| Cc: | Greg Sabino Mullane <htamfids(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Disable parallel query by default |
| Date: | 2025-05-14 15:51:33 |
| Message-ID: | 202505141551.ktrlduh6mvog@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2025-May-13, Scott Mead wrote:
> If you have a connection pool from your application and you issue 60
> queries per minute, each that can go from 1 second to 200 ms, That
> means that you are making 120 connections per minute back to the DB.
>
> As we know, connection establishment is brutal....
You're assuming that starting a parallel worker has equivalent cost to
starting a new connection, but I'm not sure that's true. Did you
measure that?
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al alfarero y ver qué formas se pueden sacar del otro" (C. Halloway en
La Feria de las Tinieblas, R. Bradbury)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Bossart | 2025-05-14 15:53:08 | Re: Statistics Import and Export |
| Previous Message | Jafri, Nazneen | 2025-05-14 15:38:03 | PostgreSQL 18 Beta 1 io_max_concurrency |