Re: High WriteLatency RDS Postgres 9.3.20

From: Andres Freund <andres(at)anarazel(dot)de>
To: Juan Manuel Cuello <juanmacuello(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: High WriteLatency RDS Postgres 9.3.20
Date: 2018-06-18 22:23:31
Message-ID: 20180618222331.acvxvstzjo7sgqpk@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2018-06-18 18:43:06 -0300, Juan Manuel Cuello wrote:
> I'm experiencing high WriteLatency levels in a Postgres server 9.3.20
> hosted in Amazon RDS.

A lot of performance improvements have been made since 9.3, and it'll
soon-ish be out of support.

If you can reproduce the issue on postgres proper, rather than a
modified version in an environment that precludes getting detailed data,
we might be able to sensibly help you further.

> So far it's been almost two months of investigation
> and people at AWS technical support don't seem to find the cause. I think
> it could be related to Postgres and the number of schema/tables in the
> database, that's why I post this issue here.

There've been improvements made since 9.3. Upgrade.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Creager 2018-06-18 22:33:54 Re: Query hitting empty tables taking 48 minutes
Previous Message Laurenz Albe 2018-06-18 22:04:20 Re: Query hitting empty tables taking 48 minutes