Обсуждение: BUG #19387: About Response time delay.

The following bug has been logged on the website:

Bug reference:      19387
Logged by:          Ashwith Thatipally
Email address:      ashwiththatipally@gmail.com
PostgreSQL version: 18.1
Operating system:   MAC
Description:

I am writing to report a significant performance issue observed with
PostgreSQL version 18.1 on macOS, which has been consistently affecting
usability over the past few days.

When using PostgreSQL 18.1 on macOS, I am experiencing severe response time
delays, including:

A 3–5 second delay between typing characters and their appearance in the
query editor/terminal.
Very slow application startup, taking nearly 2 minutes to open and become
responsive.
Overall high latency and performance degradation during basic interactions.

To rule out device-specific issues, I tested the same version on multiple
macOS machines, including a brand-new Mac laptop, and observed identical
behavior. This suggests the issue is not hardware-related.

The Windows version of PostgreSQL 18.1 does  not exhibit this problem.
PostgreSQL versions prior to 18.x on macOS were significantly more
responsive.
The macOS package appears to have notable latency issues  compared to
Windows.

I kindly request the PostgreSQL team to Investigate the **macOS-specific
performance regression** in PostgreSQL 18.1.

PG Bug reporting form <noreply@postgresql.org> writes:
> When using PostgreSQL 18.1 on macOS, I am experiencing severe response time
> delays, including:

> A 3–5 second delay between typing characters and their appearance in the
> query editor/terminal.
> Very slow application startup, taking nearly 2 minutes to open and become
> responsive.
> Overall high latency and performance degradation during basic interactions.

Nobody else has reported any such thing.  We do have a lot of PG
developers (including me) who use macOS regularly, so if there were a
generic problem of this sort I'm pretty sure we'd have heard about it.
In any case, we can't really investigate something we can't reproduce.

I suppose your problem is with the client side, since the PG server
wouldn't normally be involved in echoing individual characters.
If you're using pgAdmin, there's a separate bug reporting process
for that (this list is just about bugs in the core PG software).

            regards, tom lane

On Fri, Jan 23, 2026 at 10:16:49AM -0500, Tom Lane wrote:
> PG Bug reporting form <noreply@postgresql.org> writes:
> > When using PostgreSQL 18.1 on macOS, I am experiencing severe response time
> > delays, including:
> 
> > A 3–5 second delay between typing characters and their appearance in the
> > query editor/terminal.
> > Very slow application startup, taking nearly 2 minutes to open and become
> > responsive.
> > Overall high latency and performance degradation during basic interactions.
> 
> Nobody else has reported any such thing.  We do have a lot of PG
> developers (including me) who use macOS regularly, so if there were a
> generic problem of this sort I'm pretty sure we'd have heard about it.
> In any case, we can't really investigate something we can't reproduce.
> 
> I suppose your problem is with the client side, since the PG server
> wouldn't normally be involved in echoing individual characters.
> If you're using pgAdmin, there's a separate bug reporting process
> for that (this list is just about bugs in the core PG software).

Yeah, my guess is pgAdmin;  ror pgAdmin support, see:

    https://www.pgadmin.org/support/list/
    https://github.com/pgadmin-org/pgadmin4/issues

or email

    pgadmin-support@postgresql.org


-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.